Post reply

Restore Failure

  • March 4, 2007 at 8:14 am

    #693002

    From Books on Line:

    SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or when multiple RESTORE statements are needed (for example, a full database backup followed by a differential database backup).

    The sequence of SQL statements should be:

    -- Each time a full backup is made, a full restore needs to be performed

    Restore database xyx from disk = 'full_backup.bak'

    WITH NORECOVERY , replace

    --then for each differential:

    Restore database xyx from disk = 'differential_backup.bak'

    WITH NORECOVERY

    SQL = Scarcely Qualifies as a Language

  • March 4, 2007 at 11:20 pm

    #693024

    Thanks Carol, it worked!

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

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