Post reply

newbie: .bak file contains logs also?

  • June 8, 2006 at 9:00 am

    #62256

    I am not clear on what exactly this backup file contains

  • June 8, 2006 at 10:48 am

    #642599

    It contains whatever was backed up to it.

    I do full backups, differential backups, and log backups. For me, my backup names tell me what they are. For example:

    MyDB_Full.bak

    MyDB_Diff.bak

    MyDB_Log.bak

    Without seeing your backup commands and the file names, we can't tell you what they are.

    One thing you might try is:

    RESTORE FILELISTONLY

    That will list the backups that are in the file. Refer to the BOL for more information on the syntax.

    -SQLBill

  • June 9, 2006 at 11:57 am

    #642876

    I am not sure whats your question. If you are wondering that log file is part of the backup, then answer is yes. if you shrink the size of log file you would see that backup size of db also shrinks.

  • June 9, 2006 at 11:58 am

    #642877

    However if you truncate your log that would also decrease the size of your backup.

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

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