DB Restore With NORecovery

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  December 7, 2009 at 4:46 pm

  #217410

  Hi All,

  I have a Database full backup and some logbackups to restore.

  First I have restored full backup but unfortunately I have restored that backup with recovery option.

  Now I need to apply my remaining T-Log backups also.

  for this do I need to restore the full backup once again with norecovery option, or do we have any other option to accomplist it ?

  Thanks and Regards!!

  Thank You.

  Regards,
  Raghavender Chavva

• Bru Medishetty

  SSC-Insane

  Points: 23606

  More actions

  December 7, 2009 at 4:56 pm

  #1088953

  You need to restore the Full backup again with norecovery option.

  ---

  Bru Medishetty

  Blog -- LearnSQLWithBru

  Join on Facebook Page Facebook.comLearnSQLWithBru

  Twitter -- BruMedishetty

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736632

  More actions

  December 7, 2009 at 5:04 pm

  #1088955

  You should always restore with NORECOVERY and then when you are completely done, you can RESTORE DATABASE xx WITH RECOVERY to bring it online.