Restore backup from last year fail
Hennie
Posts: 6
I am trying to restore a backup that was made in May 2009. I get the following error:
2010/11/18 08:16:31 AM: Error 570: File is not a SQL Backup file.
The backup was created with version 5. I am now running version 6.
There is no additional information in the logs.
The backups were tested when they were created, what could cause this?
I tried restoring other backups made and they all have the same error. I do not believe it is a drive error because any file other than .sqb files are working fine.
2010/11/18 08:16:31 AM: Error 570: File is not a SQL Backup file.
The backup was created with version 5. I am now running version 6.
There is no additional information in the logs.
The backups were tested when they were created, what could cause this?
I tried restoring other backups made and they all have the same error. I do not believe it is a drive error because any file other than .sqb files are working fine.
Comments
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Could you please send me the first 1 Kb of the backup file? If you don't have a tool to do this, you can use one of our utilities. You can download it from here:
ftp://support.red-gate.com/patches/sql_backup/SBaTU.zip
Run the app in the archive, select the 'Tools > Extract file header' option, and enter the necessary parameters. Send me the resulting header file.
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
18/11/2010 11:00:02 Wrong password entered
This is strange, I did not encrypted these backups
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
18/11/2010 12:03:16 File does not exist: "\\server-dom\Retail Prod Backups\Restore\FULL_DBA_20090528_2100.sqb"