Post reply

REPLACE clause when used with differential and transaction log restore

  • March 14, 2007 at 9:20 am

    #171631

    Hi,

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

    Thanks,

    Priya

     

  • March 16, 2007 at 4:28 am

    #695411

    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.

  • March 17, 2007 at 6:35 pm

    #695591

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

     

    MohammedU
    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