Redirected restore of a SQL database fails with File '\\' is on a network device not supported for database files"

Article:TECH168312  |  Created: 2011-08-29  |  Updated: 2014-01-08  |  Article URL http://www.symantec.com/docs/TECH168312
Article Type
Technical Solution


Subject

Issue



SQL database redirected restore operations fail with an error indicating that the resource is on an unsupported network device.


Error



0xe0008492

Restore: V-79-65323-5110 - An error occurred on a query to database PRD.

V-79-65323-5110 - File '\\Server\H$\temp\data1.mdf' is on a network device not supported for database files.


Cause



A share name was entered for the path to restore database to, instead of the local volume drive letter that the share belonged to.

 


Solution



To resolve the issue, modify the restore job as follows:

1. Go to the Microsoft SQL redirect restore options

2. Select the local drive letter of the SQL server that you want the database restored to

3. Select the "Even if the original drive exists" option

 

Note:  Do not type in the UNC path to the share of that drive.

 

 

 


Supplemental Materials

SourceUMI
ValueV-79-65323-5110
Description

File '\\Server\H$\temp\data1.mdf' is on a network device not supported for database files.



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


Terms of use for this information are found in Legal Notices