Post reply

How to use LOG and LOG backup files.

  • August 27, 2008 at 3:01 am

    #382414

    Dear All,

    Can anyone tell me, how can I make use of LOG and LOG Backups in case my database crashes.

    I know that we, have to restore the latest backup and then run the LOG file. What are the steps to run the LOG file..?

    Thanks,

    Santhosh Nair.

  • August 27, 2008 at 7:46 am

    #863736

    You should read about backup and recovery in Books Online or on this site. We have a backup and recovery section in the articles section:http://www.sqlservercentral.com/Articles/Backup+and+Recovery/

    There is a lot to understand and it's hard to put it down here.

    The log file is a recording of the changes made to your database. It mirrors the database change and isn't replayed or looked at. It is not an error log, it is a log for integrity purposes.

    The log backups allow you to recover to some point in time. They are a quicker way of doing this as opposed to full backups. Full backups take more time and space, but they are needed if the database crashes.

  • August 27, 2008 at 9:16 am

    #863806

    Thanks you..

  • August 28, 2008 at 3:35 am

    #864212

    hi,

    as the first step in restoration,u need to take a log backup with no_truncate option

    then,

    restore latest full backup

    and them restore all log backups in sequence

    and as last step in restore, restore the log backup which u took with no_truncate option

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

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