Post reply

Dump Large Transactional Log Data

  • August 29, 2003 at 9:06 am

    #106449

    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

    #472227

    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

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply