Restores failing - SQL Error Code 3201

GordonGordon Posts: 10
edited August 21, 2007 10:02AM in SQL Backup Previous Versions
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

Comments

  • Eddie DEddie D Posts: 1,493 Rose Gold 3
    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: [email protected]
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
  • 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
Sign In or Register to comment.