Restore Database "with replace" - is "with move" necessary?
backup, restore, sql-server
Solution
You don't have to specify WITH MOVE.
Problem
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?