All geek questions in one place

Restore the database "with replacement" - is there a "move"?

A database backup was created with files in location A Then the database files are moved to location B using ALTER DATABASE MODIFY FILE

Now restore the backup using WITH REPLACE, created when the files were in location A. Should the WITH MOVE parameter specify a new location? Or WITH REPLACE means using current locations no matter where they were when the backup was created?

+3
source share
2 answers

You do not need to specify WITH MOVE.

+4
source

, Microsoft SQL Server 2012 2008 . A, B, "WITH REPLACE" "WITH MOVE" SQL 2005/2008, A . B ( ). , SQL 2012, , "WITH MOVE".

, , , Microsoft...

0

Source: https://habr.com/ru/post/1713249/

More articles:


All Articles