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

Restore Error

ToehoToeho Posts: 73
edited November 21, 2007 3:13AM in SQL Backup Previous Versions
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

Comments

  • Options
    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??
  • Options
    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
    James Moore
    Head of DBA Tools
    Red Gate Software Ltd
Sign In or Register to comment.