Friday, February 17, 2012

Database Log file

Newby question. I've got a very big database log file (not been managed). It won't let me delete it. How do I clear it?Check out this thread:

http://www.dbforums.com/t1049765.html

Should have the info you want...

Basically Backup the DB.. Then shrink your log file..|||1. backup log with truncate_only
2. dbcc shrinkfile 'logfile'

also u can deattach the database - delete the transaction log file - attach back the database.
Remember, always take a backup before deattaching the database.

also check this link for more info on transaction log (http://www.nigelrivett.net/TransactionLogFileGrows_1.html)

No comments:

Post a Comment