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

Restore is failing

faisfais Posts: 21
edited February 2, 2010 1:57PM in SQL Backup Previous Versions
I am trying to restored red-gate backup on SQL Server 2005 and getting this error. Can anyone help me.

Error :

2/1/2010 9:37:51 PM: Thread 0 error:
EOF#2 validation failed. Device 1. Expected 304283, available 21300. Error 1130 (Not enough server storage is available to process this command.).
2/1/2010 9:37:51 PM:
2/1/2010 9:37:51 PM: Thread 1 error:
EOF#2 validation failed. Device 1. Expected 304283, available 21300. Error 1130 (Not enough server storage is available to process this command.).
2/1/2010 9:37:51 PM:
2/1/2010 9:37:52 PM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
2/1/2010 9:37:52 PM: SQL error 3241: SQL error 3241: The media family on device 'SQLBACKUP_3F3DA2B1-5042-4687-A807-9C4D284CB4A8' is incorrectly formed. SQL Server cannot process this media family.


Thanks

Comments

  • Options
    Looks like you're out of disk space where you trying to restore the database. Generally you want equal amount of diskspace plus a few GBs to give the db engine enough room to restore the database. You should check the event viewer app or system log. There should be some entries regarding disk space and the drive letter.
    fais wrote:
    I am trying to restored red-gate backup on SQL Server 2005 and getting this error. Can anyone help me.

    Error :

    2/1/2010 9:37:51 PM: Thread 0 error:
    EOF#2 validation failed. Device 1. Expected 304283, available 21300. Error 1130 (Not enough server storage is available to process this command.).

    Thanks
Sign In or Register to comment.