REPLACE clause when used with differential and transaction log restore

  • Hi,

    What REPLACE clause does when used while restoring the transaction log and differential backup?




  • Hi,

    REPLACE clause should be used if you want to overwrite the existing database or its related files thro' restore. With REPLACE clause, SQL Server does not conduct the saftey check

    before restoring the database. It simply overwrite the mdf and ldf files.

  • Read BOL topic "Using the REPLACE Option" for complete details...


    Microsoft SQL Server MVP

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

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