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)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment