Restore Error

Toeho

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

Toeho

It appears my problem was trying tp restore via UNC as after I copied the files to the local server I was able to do the restore. Is there a threshhold that you should not go above when doing a restore from a unc path, this backup file is close to 60gb in size??

James Moore

Toeho,

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