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

Unable to restore backup made on another server

Hi,

I am unable to restore a backup on one of my (SQL Server 2005) servers that was created on another server. Both servers appear to have the same version of SQL Server and the same version of SQL Backup. I have been doing this process on the same two servers for a couple years without issue, but now the second server does not recognize backups made on the first server. (NOTE: I am able to make a backup on server two and restore to server one)

I am using the restore wizard and when I select the backup file, the wizard indicates that the Date, Type, Fist LSN, etc are all unknown.

Both Servers have the same version of SQL Server:
Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Both Servers have the same version of SQL Backup:
5.3.0.178

Any suggestions?

Thanks,
Billy
billyt
0

Comments

4 comments

Sort by
  • petey
    Could you please run the following against the 2 servers using SSMS and post the results? Thanks.
    DECLARE @version nvarchar(16)
EXEC master..sqbutility 1030, @version OUTPUT
SELECT @version
    petey
    0
  • billyt
    The server I am making the backups on returns: 6.4.0.56

    The server I am trying to restore on returns: 5.3.0.178

    So what do I do to get the versions synched up?

    Thanks for your quick reply,
    Billy
    billyt
    0
  • petey
    On the machine where you have 6.4.0.56 installed, in the SQL Backup installation folder, there should be a file named SQBServerSetup.exe. Copy that file to the machine running 5.3.0.178. Ensure that no SQL Backup backups/restores are running, and that no SQL Backup GUIs are connected to that instance. Stop the SQL Backup Agent service, and run the server setup file (SQBServerSetup.exe) to upgrade that installation of SQL Backup to 6.4.0.56.
    petey
    0
  • billyt
    Thanks Peter, that fixed it. Billy
    billyt
    0

Add comment

Please sign in to leave a comment.