Restoring Log File more than once

• Wookie DBA

  Say Hey Kid

  Points: 705

  More actions

  September 16, 2005 at 10:29 am

  #110007

  If you restore a log file more than once, will the data be correct?

  We have a process that restores the most current logfile from our Production system to our DR system.  The logs are continually restored with the 'NORECOVERY' option set.  Can I just restore the last one again with the 'RECOVER' option set to get the database online, or will that corrupt the data?

  thanks

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  September 16, 2005 at 11:15 am

  #590683

  You can just run this:

   restore 'database name' with recovery

  you don't even need to give it a backup or log file, it will just bring it online.