Welcome To DBA Share

Database restore failing with move clause can be used to relocate one or more files.

0 comments

Today I got an error in restoring a database on a test server. The database has 30 files which includes 1 data file, 1 log file and remains are .ndf files. please check the below error which i got while i restore the database.


I have checked the restore query that one is correct

solution is here very simple....! Physical files which will move to physical location should have different name. i have given different name and again i ran Restore query. This time query ran successfully. 
Share this article :

Post a Comment

 
Support : 2005 | 2008 | 2008R2 | 2012 | 2014 | SQL Server DBA
Copyright © 2013. DBA Share - All Rights Reserved
Template Created by Creating Website Modify by CaraGampang.Com
Proudly powered by Blogger