Mssql 2008 R2 Restore Error:
File '.ndf' is claimed by (4) and (3). The WITH MOVE clause can be used to relocate one or more files.
Solutions:
1.
Restore behavior for new DB was changed in SQL 2008:
Restore behavior for new DB was changed in SQL 2008:
In 2005, we can create new (empty) DB and restore from bak file to the new DB.
In 2008, Restore from bak file to new DB (that was not created yet).
(Right click on Databases-->Restore Database...)
(Right click on Databases-->Restore Database...)
Another possible causes of the problem can be (not only for MSSQL 2008):
2.
Different number of files between the new DB and the source DB.
3.
Attempting to use a file for more than one purpose.
This post helped me around the issue, when a lot of searching elsewhere did not. Huge kudos for this simple and effective explanation.
ReplyDeleteYou welcome, Thanks for the feedback!
ReplyDeleteThanks for this, very simple answer to a complicated error for those new to SQL 2008
ReplyDelete