How to use SQL Backup to restore to a different server?

matthewf · August 17, 2011 12:18PM

Hi,
i am using SQL Backup (6.4.0.56) to backup all my db servers. I like the compression achievable with the compressed SQB files.

In this case my question is about two servers - we'll call them prodserver and testserver. Both servers have a db called mydb. The copy of mydb on testserver is months old.

I need to backup the mydb database from prodserver and restore it over the top of the mydb database on testserver; thus 'refreshing' my testserver database with a copy of production.

can i do this with sql backup 6? i don't seem to be seeing how...

Thanks!

petey · August 17, 2011 9:51PM

Assuming you are backing up the database to the local disk:

- you could copy the backup file to a network share on your testserver using the COPYTO option (described here)
- then restore from that backup file on your testserver using the LATEST_FULL option (described here)
- or you could skip the copy step and restore directly from the prodserver, but you would need to share out the backup folder

matthewf · October 5, 2011 5:54PM

Ok - thank you for the reply.
So my follow up questions are:
1) so there is not a way to do this through the Redgate SQL backup gui then?
2) should that syntax you referenced work with sqb files? or is that for native sql backups?

Thanks again
Matt

petey · October 5, 2011 9:42PM

You can schedule a backup job which copies the backup file to a network share using the SQL Backup GUI.

You cannot use the SQL Backup GUI to schedule a restore job that restores the latest full backup set.

The COPYTO and LATEST_FULL options are all SQL Backup syntax elements, and will not work with native SQL Server backups.

Thanks.

How to use SQL Backup to restore to a different server?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk