Options
Restore Error
Toeho
Posts: 73
Getting the following error when attempting to do a restore. No errors were recieved durring the intial backup.
RedGate
REDGATE Restore
EXEC master.dbo.sqlbackup N'-SQL "RESTORE DATABASE [JDE_DEVELOPMENT] FROM DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_01.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_02.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_03.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_04.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_05.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_06.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_07.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_08.sqb'' WITH RECOVERY, MOVE ''JDE_PRODUCTION_Data'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT_Data.mdf'',
MOVE ''JDE_PRODUCTION_log'' TO ''k:\MSSQL\Logs\JDE_DEVELOPMENT_log.LDF'',
MOVE ''JDE_PRODUCTION17'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT17_Data.NDF'',
MOVE ''JDE_PRODUCTION3'' TO ''h:\MSSQL\Data\JDE_DEVELOPMENT3_Data.NDF'',
MOVE ''JDE_PRODUCTION2'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT2_Data.NDF'',
MOVE ''JDE_PRODUCTION5'' TO ''g:\MSSQL\Data\JDE_DEVELOPMENT5_Data.NDF'',
MOVE ''JDE_PRODUCTION6'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT6_Data.NDF'',
MOVE ''JDE_PRODUCTION7'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT7_Data.NDF'',
MOVE ''JDE_PRODUCTION8'' TO ''i:\MSSQL\Data\JDE_DEVELOPMENT8_Data.NDF'',
MOVE ''JDE_PRODUCTION9'' TO ''i:\MSSQL\Data\JDE_DEVELOPMENT9_Data.NDF'',
MOVE ''JDE_PRODUCTION10'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT10_Data.NDF'',
MOVE ''JDE_PRODUCTION11'' TO ''g:\MSSQL\Data\JDE_DEVELOPMENT11_Data.NDF'',
MOVE ''JDE_PRODUCTION12'' TO ''h:\MSSQL\Data\JDE_DEVELOPMENT12_Data.NDF'',
MOVE ''JDE_PRODUCTION13'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT13_Data.NDF'',
MOVE ''JDE_PRODUCTION14'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT14_Data.NDF'',
MOVE ''JDE_PRODUCTION14'' TO ''g:\MSSQL\Data\JDE_DEVELOPMENT15_Data.NDF'',
MOVE ''JDE_PRODUCTION16'' TO ''h:\MSSQL\JDE_DEVELOPMENT16_Data.NDF'',
MOVE ''JDE_PRODUCTION18'' TO ''h:\MSSQL\JDE_DEVELOPMENT18_Data.NDF'',
MOVE ''F0911_1_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_1_INDEX.ndf'',
MOVE ''F0911_6_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_6_INDEX.ndf'',
MOVE ''F0911_8_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_8_INDEX.ndf'',
MOVE ''F0911_9_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_9_INDEX.ndf'',
MOVE ''F0911_10_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_10_INDEX.ndf'',
MOVE ''F0911_11_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_11_INDEX.ndf'',
MOVE ''F0911_12_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_12_INDEX.ndf'',
MOVE ''F0911_13_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_13_INDEX.ndf'',
MOVE ''F0911_14_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_14_INDEX.ndf'',
MOVE ''F0911_15_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_15_INDEX.ndf'',
MOVE ''F0911_16_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_16_INDEX.ndf'',
MOVE ''F0911_17_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_17_INDEX.ndf'',
MOVE ''F0911_18_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_18_INDEX.ndf'',
MOVE ''F0911_19_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_19_INDEX.ndf'',
MOVE ''F0911_20_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_20_INDEX.ndf'',
MOVE ''F0911_23_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_23_INDEX.ndf'',
MOVE ''F0911_24_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_24_INDEX.ndf'',
MOVE ''F0911_25_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_25_INDEX.ndf'',
MOVE ''F0911_27_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_27_INDEX.ndf'',
MOVE ''F0911_28_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_28_INDEX.ndf'',
MOVE ''F0911_32_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_32_INDEX.ndf'',
MOVE ''F0911_34_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_34_INDEX.ndf'', REPLACE, PASSWORD = ''xxx''"'
SQL Backup v4.6.0.815
Restoring JDE_DEVELOPMENT (database) from:
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_01.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_02.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_03.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_04.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_05.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_06.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_07.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_08.sqb
Thread 4 error:
File read error for 92429 bytes (balance 37204 bytes). Backup file is incomplete or corrupted.
SQL Server error
Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3203
Read on 'SQLBACKUP_6B493D8C-B4F5-4965-95DE-4129B649FBB004' failed, status = 995. See the SQL Server error log for more details.
SQL Backup exit code: 1100
SQL error code: 3203
name value
exitcode 1100
sqlerrorcode 3203
filename01 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_01.sqb
filename02 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_02.sqb
filename03 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_03.sqb
filename04 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_04.sqb
filename05 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_05.sqb
filename06 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_06.sqb
filename07 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_07.sqb
filename08 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_08.sqb
RedGate
REDGATE Restore
EXEC master.dbo.sqlbackup N'-SQL "RESTORE DATABASE [JDE_DEVELOPMENT] FROM DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_01.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_02.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_03.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_04.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_05.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_06.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_07.sqb'', DISK = ''\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_08.sqb'' WITH RECOVERY, MOVE ''JDE_PRODUCTION_Data'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT_Data.mdf'',
MOVE ''JDE_PRODUCTION_log'' TO ''k:\MSSQL\Logs\JDE_DEVELOPMENT_log.LDF'',
MOVE ''JDE_PRODUCTION17'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT17_Data.NDF'',
MOVE ''JDE_PRODUCTION3'' TO ''h:\MSSQL\Data\JDE_DEVELOPMENT3_Data.NDF'',
MOVE ''JDE_PRODUCTION2'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT2_Data.NDF'',
MOVE ''JDE_PRODUCTION5'' TO ''g:\MSSQL\Data\JDE_DEVELOPMENT5_Data.NDF'',
MOVE ''JDE_PRODUCTION6'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT6_Data.NDF'',
MOVE ''JDE_PRODUCTION7'' TO ''f:\MSSQL\Data\JDE_DEVELOPMENT7_Data.NDF'',
MOVE ''JDE_PRODUCTION8'' TO ''i:\MSSQL\Data\JDE_DEVELOPMENT8_Data.NDF'',
MOVE ''JDE_PRODUCTION9'' TO ''i:\MSSQL\Data\JDE_DEVELOPMENT9_Data.NDF'',
MOVE ''JDE_PRODUCTION10'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT10_Data.NDF'',
MOVE ''JDE_PRODUCTION11'' TO ''g:\MSSQL\Data\JDE_DEVELOPMENT11_Data.NDF'',
MOVE ''JDE_PRODUCTION12'' TO ''h:\MSSQL\Data\JDE_DEVELOPMENT12_Data.NDF'',
MOVE ''JDE_PRODUCTION13'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT13_Data.NDF'',
MOVE ''JDE_PRODUCTION14'' TO ''j:\MSSQL\Data\JDE_DEVELOPMENT14_Data.NDF'',
MOVE ''JDE_PRODUCTION14'' TO ''g:\MSSQL\Data\JDE_DEVELOPMENT15_Data.NDF'',
MOVE ''JDE_PRODUCTION16'' TO ''h:\MSSQL\JDE_DEVELOPMENT16_Data.NDF'',
MOVE ''JDE_PRODUCTION18'' TO ''h:\MSSQL\JDE_DEVELOPMENT18_Data.NDF'',
MOVE ''F0911_1_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_1_INDEX.ndf'',
MOVE ''F0911_6_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_6_INDEX.ndf'',
MOVE ''F0911_8_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_8_INDEX.ndf'',
MOVE ''F0911_9_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_9_INDEX.ndf'',
MOVE ''F0911_10_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_10_INDEX.ndf'',
MOVE ''F0911_11_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_11_INDEX.ndf'',
MOVE ''F0911_12_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_12_INDEX.ndf'',
MOVE ''F0911_13_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_13_INDEX.ndf'',
MOVE ''F0911_14_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_14_INDEX.ndf'',
MOVE ''F0911_15_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_15_INDEX.ndf'',
MOVE ''F0911_16_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_16_INDEX.ndf'',
MOVE ''F0911_17_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_17_INDEX.ndf'',
MOVE ''F0911_18_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_18_INDEX.ndf'',
MOVE ''F0911_19_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_19_INDEX.ndf'',
MOVE ''F0911_20_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_20_INDEX.ndf'',
MOVE ''F0911_23_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_23_INDEX.ndf'',
MOVE ''F0911_24_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_24_INDEX.ndf'',
MOVE ''F0911_25_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_25_INDEX.ndf'',
MOVE ''F0911_27_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_27_INDEX.ndf'',
MOVE ''F0911_28_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_28_INDEX.ndf'',
MOVE ''F0911_32_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_32_INDEX.ndf'',
MOVE ''F0911_34_INDEX'' TO ''j:\JDE_DEVELOPMENT_F0911_34_INDEX.ndf'', REPLACE, PASSWORD = ''xxx''"'
SQL Backup v4.6.0.815
Restoring JDE_DEVELOPMENT (database) from:
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_01.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_02.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_03.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_04.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_05.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_06.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_07.sqb
\\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_08.sqb
Thread 4 error:
File read error for 92429 bytes (balance 37204 bytes). Backup file is incomplete or corrupted.
SQL Server error
Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
Server: Msg 3203
Read on 'SQLBACKUP_6B493D8C-B4F5-4965-95DE-4129B649FBB004' failed, status = 995. See the SQL Server error log for more details.
SQL Backup exit code: 1100
SQL error code: 3203
name value
exitcode 1100
sqlerrorcode 3203
filename01 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_01.sqb
filename02 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_02.sqb
filename03 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_03.sqb
filename04 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_04.sqb
filename05 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_05.sqb
filename06 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_06.sqb
filename07 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_07.sqb
filename08 \\leddtc\w$\Backups\JDE_PRODUCTION_11202007_063312_FULL_08.sqb
Comments
There is no theoretical limit placed on this by SQL Backup (There may be some from file systems etc), however this sort of error can be caused by intermittent network connectivity loss.
Where there any short term outages during the restore process?
James
Head of DBA Tools
Red Gate Software Ltd