Post reply

Restore log stop at option

  • February 28, 2013 at 9:10 am

    #290131

    Why do we use "STOPAT" option while restoring logs to database?

    Thanks

  • February 28, 2013 at 9:43 am

    #1592058

    To accomplish a point in time recovery. You this clause when you want to restore a database to a specific point in time, prehaps to capture data that was accidentally deleted.

  • February 28, 2013 at 9:51 am

    #1592066

    But you can still do without STOPAT clause right?

    Then why to add key word STOPAT?

    Thanks

  • February 28, 2013 at 10:15 am

    #1592087

    To accomplish a point in time restore you need the STOPAT = 'datetime' as part of the RESTORE LOG command.

    Here is a link to MSDN: http://msdn.microsoft.com/en-us/library/ms186858(v=sql.100).aspx

  • February 28, 2013 at 10:38 am

    #1592100

    Admingod (2/28/2013)

    But you can still do without STOPAT clause right?

    Not if you want to stop in the middle of a log backup. If your log backups are hourly and you want to restore to the time 15:27:23, then you need a STOPAT. Without that, you can only restore entire logs, so 15:00 or 16:00

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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