File 'SqlPath' is claimed by 'Filename' (65538) and 'Filename' (65537) occurs when running redirected SQL Restore

Article:TECH171168  |  Created: 2011-10-05  |  Updated: 2013-04-05  |  Article URL http://www.symantec.com/docs/TECH171168
Article Type
Technical Solution


Subject

Issue



When running a redirected restore of a SQL Database the restore fails with "The WITH MOVE clause can be used to relocate one or more files."


Error



v-79-65323-3176 - File 'SqlPath' is claimed by 'Filename' (65538) and 'Filename' (65537). The WITH MOVE clause can be used to relocate one or more files.

 


Cause



This can happen when SQL is seeing files that may be there and it cannot overwrite. It will suggest to redirect the file to a different location. This can also occur if the original database had multiple files with the same name, and the files are being redirected to the same location.


Solution



Redirect the SQL database using file and path to a different location which is not in use.


Supplemental Materials

Valuev-79-65323-3176
Description

The WITH MOVE clause can be used to relocate one or more files

 



Article URL http://www.symantec.com/docs/TECH171168


Terms of use for this information are found in Legal Notices