Post reply

Restore Differential with Replace

  • April 15, 2011 at 9:09 am

    #235788

    Scenario:

    1. Database is restored from full backup using the WITH REPLACE, NORECOVERY option.

    2. Database is then restored from differential backup using the WITH REPLACE, RECOVERY option.

    My understanding is that the differential just REPLACED the full database restore with only the data that was in the differential backup.

    Is this correct?

  • April 15, 2011 at 9:24 am

    #1312219

    No. What's in the Diff is not a complete database, it's just the extents that have changed since the full that the diff is based on.

    I suspect the replace on the diff is ignored. It makes no more sense than restoring a log with replace.

    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 2 posts - 1 through 1 (of 1 total)

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