Restore Database "with replace" - is "with move" necessary?

12,662

You don't have to specify WITH MOVE.

Share:
12,662
Aidan Ryan
Author by

Aidan Ryan

Developer, musician, comic book fan, LEGO maniac.

Updated on June 04, 2022

Comments

  • Aidan Ryan
    Aidan Ryan almost 2 years

    Database backup was created with files in location A Database files then moved to location B using ALTER DATABASE MODIFY FILE

    Now restoring the backup using WITH REPLACE created when files were in location A. Should the WITH MOVE option be specified with the new location? Or does WITH REPLACE imply using the current locations regardless of where they were when the backup was created?