August 29, 2003 at 9:06 am
Hi All,
I have a database with a 24 GB transaction log file. I want to dump and shrink this file to free up space. If a full database backup is performed, can we say the full backup contains all the data (committed) and it is safe to dump the transaction log data?
Please advise what is the best practice to handle this situation.
Thank you in advance for your inputs!
Yichang
September 1, 2003 at 8:00 am
This was removed by the editor as SPAM
September 2, 2003 at 10:53 am
Yepper, sorta. SQL won't let you truncate an uncommitted transaction. If you do a full backup potentially transactions are still occurring, so you need to either set your recovery mode to simple or continue to do log backups. All a full backup does is guarantee you can recover the entire db to a consistent state.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply