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

Compresses, encrypts, secures and monitors SQL Server backups.

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

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

Postby beachldy » Mon Jun 25, 2012 1:07 pm

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.
beachldy
 
Posts: 10
Joined: Wed Sep 14, 2005 9:53 pm

Postby Marianne » Mon Jun 25, 2012 1:44 pm

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
Marianne
 
Posts: 45
Joined: Mon Oct 03, 2011 3:24 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests