Restores failing - SQL Error Code 3201

Gordon

I've been running SQLBackup v4 for months with no problem and now all my restores are failing with "Failed to read file list from backup file", error code 3201.
The error log says:

"Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)"

Last night the SQL service pack version on our restore machine was updated (don't ask!) so we've now got SQL 2005 SP1 on the box being backed up and SQL 2005 SP2 on the restore box. Would this cause the error?

cheers

Eddie D

Hi Gordon

Can you please post the complete SQL Backup Log file for the restore job. The SQL Backup Log file is available at the following default location C:\Documents and settings\All Users\Application data\Red Gate\SQL Backup\Log\(LOCAL) or SQL Instance Name or path set in theOptions->Log Files Tab.

Also the error message "Failed to read file list from backup file" suggests that the backup file header has corrupted.

However we do see this error when users attempt to restore from a SQL 2005 backup to a SQL 2000 database.

Please try restoring using the header only as follows from a new query in SSMS:

master..sqlbackup '-SQL "RESTORE SQBHEADERONLY FROM DISK = 'C:\Backups\*.sqb' " '

Replacing C:\Backups\*.sqb for the path to your backup file.

RESTORE HEADERONLY which retrieves the header information from the backup file. Once the file header as been read you should see information concerning the backup which includes the start and finish LSN's, server and database names, backup type and backup start / finish times.

Many Thanks
Eddie

Eddie Davis
Tecnical Support
Red Gate Software Ltd
E-Mail: support@red-gate.com

Gordon

Hi Eddie

Thanks for the reply. We updated the live box so both were running SQL SP2 and this has have fixed the problem so it looks like a service pack mismatch.

thanks for your help.

Gordon