IsThere A way Easiest to clear Log File

alyeng2000 · July 11th, 2004, 04:28 PM

Actually I Need To Delete The Log File Or Remove Its Contents

i have one way but is there a way else
my way is two generate a script file and make a new db and then import data....

Ahmed Ali
Software Developer

dhay1999 · July 20th, 2004, 09:11 AM

Check this URL:

hope it helps!

http://www.mssqlcity.com/FAQ/Trouble/LogTrunc.htm

defiant · August 5th, 2004, 11:51 AM

I use the following script (replace dbname with the name of the database):

backup log dbname with no_log
dbcc shrinkdatabase(dbname, 0)

remember to do a backup before, just in case.

the script can be run in SQL Query Analyzer, for example.

alyeng2000 · August 5th, 2004, 04:10 PM

it works

Ahmed Ali
Software Developer