SQL redirect restore job fails if destination machine path is selected through the browse button
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):
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
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.".
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).
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).