How can we help you today? How can we help you today?

Restore backup from last year fail

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.
Hennie
0

Comments

7 comments

  • petey
    Could you please post the exact version you are using? Please check the version of SQBCoreService.exe, the SQL Backup Agent service executable file.

    Thanks.
    petey
    0
  • Hennie
    I am using SQLBackup 6.4.0.56
    Hennie
    0
  • petey
    That is the latest release version, and should be backwards compatible with all earlier versions of SQL Backup.

    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.
    petey
    0
  • Hennie
    18/11/2010 11:00:02 Encrypted
    18/11/2010 11:00:02 Wrong password entered

    This is strange, I did not encrypted these backups
    Hennie
    0
  • petey
    If you select the 'Extract file header' option, it will just copy the first x bytes into a separate file. There isn't a need to enter a password.

    Thanks.
    petey
    0
  • Hennie
    This is what I get

    18/11/2010 12:03:16 File does not exist: "\\server-dom\Retail Prod Backups\Restore\FULL_DBA_20090528_2100.sqb"
    Hennie
    0
  • Hennie
    Email send with results
    Hennie
    0

Add comment

Please sign in to leave a comment.