Restoring to a different SQL Server

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Restoring to a different SQL Server

Postby maddave » Tue May 14, 2013 3:41 pm

Hi,
Everything I read seems to say this is possible through the GUI, but I cannot see the option to do it.
I am trying to restore a database taken on ServerA, via SQL Backup, to ServerB using SQL Backup Gui. Lets say to allow a test server to be created.

ServerA is taking regular daily backups created using the GUI Tool.
I have added ServerB to the GUI and installed the server components and licensed it.
I right click on ServerB, select restore. I then select "browse for backup files to restore" and select ServerA as the backup to restore.
I then click on Add files and browse to my central backup store and select the last full backup for ServerA.
I then click Next, but shown a screen "step 2 of 4", which shows the Destination Database is set to ServerA - the original SQL Server and I cannot change this. I only have the options to overwrite the existing database or create a new one. I tested this and created a new one and it does indeed write the backup to the original server.

This article http://www.red-gate.com/supportcenter/c ... 0710000174
explains this process as I have, but no where does it say you can restore the database to a different sql server, despite it's title!

Any help would be great.

Thanks.

*******EDIT***
I've just realised my mistake with this and now have it working. It's not clear on the screens, but the first screen, I should leave set at Server B, and then simply add files from ServerA. On the "step 1 of 4" it says "Backups to restore SQL Server:..." And this drop down should be set to the destination SQL Server, not as it implies, the source SQL Server. I have this working now.
maddave
 
Posts: 19
Joined: Thu Apr 11, 2013 11:48 am

Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 1 guest