Hi there,
I'm having an issue trying to restore a red gate backup using UNC path location.
WORKS:
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE TESTDB FROM Disk=''h:\TESTDB\FULL_TESTDB_20081110_143936.sqb'' WITH REPLACE, RECOVERY,
MOVE ''TESTDB'' TO ''F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'',
MOVE ''TESTDB_log'' TO ''G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'''
FAILS:
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE TESTDB FROM Disk=''\\<IP ADDRESS>\h$\TESTDB\FULL_TESTDB_20081110_143936.sqb'' WITH REPLACE, RECOVERY,
MOVE ''TESTDB'' TO ''F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'',
MOVE ''TESTDB_log'' TO ''G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'''
These are the errors reported by SQL Backup:
Restoring TESTDB (database) on DBGHOST instance from:
\\<IP ADDRESS>\h$\TESTDB\FULL_TESTDB_20081110_143936.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3119: SQL error 3119: Problems were identified while planning for the RESTORE statement. Previous messages provide details.
SQL error 3156: SQL error 3156: File 'TESTDB_log' cannot be restored to 'G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'. Use WITH MOVE to identify a valid location for the file.
SQL error 3634: SQL error 3634: The operating system returned the error '32(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'.
SQL error 3156: SQL error 3156: File 'TESTDB' cannot be restored to 'F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'. Use WITH MOVE to identify a valid location for the file.
SQL error 3634: SQL error 3634: The operating system returned the error '32(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'.
SQL Backup exit code: 1100
SQL error code: 3634
Is there an issue with using a UNC path vs a local path??
Im using SQL Backup 5.
Thanks in advance.
I'm having an issue trying to restore a red gate backup using UNC path location.
WORKS:
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE TESTDB FROM Disk=''h:\TESTDB\FULL_TESTDB_20081110_143936.sqb'' WITH REPLACE, RECOVERY,
MOVE ''TESTDB'' TO ''F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'',
MOVE ''TESTDB_log'' TO ''G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'''
FAILS:
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE TESTDB FROM Disk=''\\<IP ADDRESS>\h$\TESTDB\FULL_TESTDB_20081110_143936.sqb'' WITH REPLACE, RECOVERY,
MOVE ''TESTDB'' TO ''F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'',
MOVE ''TESTDB_log'' TO ''G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'''
These are the errors reported by SQL Backup:
Restoring TESTDB (database) on DBGHOST instance from:
\\<IP ADDRESS>\h$\TESTDB\FULL_TESTDB_20081110_143936.sqb
SQL Server error
SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3119: SQL error 3119: Problems were identified while planning for the RESTORE statement. Previous messages provide details.
SQL error 3156: SQL error 3156: File 'TESTDB_log' cannot be restored to 'G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'. Use WITH MOVE to identify a valid location for the file.
SQL error 3634: SQL error 3634: The operating system returned the error '32(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'.
SQL error 3156: SQL error 3156: File 'TESTDB' cannot be restored to 'F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'. Use WITH MOVE to identify a valid location for the file.
SQL error 3634: SQL error 3634: The operating system returned the error '32(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'F:\MSSQL.6\MSSQL\Data\TESTDB.mdf'.
SQL Backup exit code: 1100
SQL error code: 3634
Is there an issue with using a UNC path vs a local path??
Im using SQL Backup 5.
Thanks in advance.