DB Restore With NORecovery

  • 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

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


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

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

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

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