SQL redirect restore job fails if destination machine path is selected through the browse button

Problem

SQL redirect restore job fails if destination machine path is selected through the browse button

Error Message

During a SQL redirect restore if the browse button is used to specify an alternate path to redirect the SQL data files the job will fail with the following error (FIGURE 1):


ERROR:

Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors
For additional information regarding this error refer to link V-79-57344-33938

Restore- BE-SRVC\BKUPEXEC V-79-65323-5110 - An error occurred on a query to database HRDB.
V-79-65323-5110 - The file "\\BE-SRVC\V$\SQL_RESTORE\HRDB_dat.mdf" is on a network path that is not supported for database files


EVENT ID ON SQL SERVER:

Event Type: Error
Event Source: Backup Exec
Event Category: None
Event ID: 57859
Description:
An error occurred while executing the following query: "RESTORE DATABASE [HRDB] FROM virtual_device = 'HRDB_00__4a94dc6a_70f7_4195_a841_0591f2ec08c9_' WITH NORECOVERY , MOVE 'hrdb_dat' TO '\\BE-SRVC\V$\SQL_RESTORE\HRDB_dat.mdf', MOVE 'HRdb_log' TO '\\BE-SRVC\V$\SQL_RESTORE\HRDB_log.ldf'".
On server: "BE-SRVC".
SQL error number: "13F6".
SQL error message: "The file "\\BE-SRVC\V$\SQL_RESTORE\HRDB_dat.mdf" is on a network path that is not supported for database files.".


(FIGURE 1)
 
 

Cause

In the restore job under Microsoft SQL Redirection job setup the Destination Option - Use this path contains a UNC Network path when using the browse button to specify a data directory to restore to (FIGURE 2).

(FIGURE 2)

Solution

This issue has been fixed in Backup Exec 2012 and above.
 

WORKAROUND:
 
Workaround for versions earlier that Backup Exec 2012

Remove the UNC Network path under Destination Option and manually type in the physical drive letter and path for the data directory to restore to such as F:\SQL_Restore where F: is the drive on the SQL Server and the database the restore is being redirected to is located in the SQL Server path of F:\SQL_Restore. (FIGURE 3).

(FIGURE 3)
  


 
 

 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)