Red Gate forums :: View topic - How to restore from one server to another using Sql Backup?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

How to restore from one server to another using Sql Backup?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
beachldy



Joined: 14 Sep 2005
Posts: 10

PostPosted: Mon Jun 25, 2012 1:07 pm    Post subject: How to restore from one server to another using Sql Backup? Reply with quote

Am trying to test the SQL Backup before activating it. I noticed that although we just recently purchased it, it's only version 6.5. Anyhow, when testing a restore, I'm wanting to restore from ONE SERVER and DATABASE to a DIFFERENT SERVER and Database, and cannot find that option.
Back to top
View user's profile Send private message
Marianne



Joined: 03 Oct 2011
Posts: 45

PostPosted: Mon Jun 25, 2012 1:44 pm    Post subject: Reply with quote

Hi,

You can restore a backup from one server to an existing or new database on a different server using the Restore wizard (in v6.5 and v7+) or the Schedule Restore Jobs wizard (v7+ only).

To restore a backup to a different server using the Restore wizard:
- On step 1 select Browse for backups to restore from the drop-down list.
- Then specify the server you want to restore the backup to.
- Click Add files to open the File Browser and browse for backup files to restore. Backups stored on the server you are restoring to are displayed. You can view backups stored on another server by selecting the server from the drop-down list, or clicking Add server to add another server.
- Proceed through the rest of the wizard as normal.

Further information, including how to restore from a different server using the Schedule Restore Jobs wizard, is available here: http://www.red-gate.com/supportcenter/Content/SQL_Backup/help/7.1/SBU_BackUpRestoreNetworkShare

Finally, if you would like to evaluate SQL Backup 7, you can download a free trial from our website here: http://www.red-gate.com/products/dba/sql-backup/

I hope that helps.

Thanks,

Marianne
_________________
Marianne Crowder
Red Gate Software Limited
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group