Re: [development-axapta] How to delete log file from SQL Server 2000 Solve

Hi, "Backup log DBNAME with no_log" command will truncate the db log. The shrink database will free the unused space in the database to the file system. At the end the log file will be its initial size. --- subhamit59 <[EMAIL PROTECTED]> wrote: > Hi, > > Yes, you can delete the LoG file any

[development-axapta] How to delete log file from SQL Server 2000 Solve

Hi, Yes, you can delete the LoG file any time. First detach the databse from the sql server. Delete the log file. Attach the Data base again. It will ask for the log file. Specify a new log file name. You can do it by using Entp. Manager or Analyzer. Note: First take a full backup of the Dat