Post reply

understanding with Replace option in restoring database

  • January 6, 2014 at 2:33 am

    #286921

    I was unable to restore database because of missing backup file and got LSN

    error then I tried to restore my database from object explorer in sql 2008 having option of restoring database with REPLACE.I got successfully restored and recovered.

    I wanted to know How exactly REPLACE key word works in restoring database.

  • January 6, 2014 at 2:41 am

    #1677671

    It tells SQL you don't care about the database that you're overwriting so not to give you the errors that you are losing data due to overwriting the DB.

    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