What are the challenges you face when working across database platforms? Take the survey
Options

Restore backup failed with error 1100; using UNC path

tdpgmantdpgman Posts: 5
edited November 10, 2008 9:17PM in SQL Backup Previous Versions
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.

Comments

  • Options
    peteypetey Posts: 2,358 New member
    The message for error code 32 is 'The process cannot access the file because it is in use by another process.'.

    Could you please check if the file is currently used by another database e.g.
    SELECT * FROM master..sysaltfiles WHERE filename IN &#40;'F:\MSSQL.6\MSSQL\Data\TESTDB.mdf', 'G:\MSSQL.6\MSSQL\Data\TESTDB_log.ldf'&#41;
    
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.