How to use SQL Backup to restore to a different server?
i am using SQL Backup (18.104.22.168) 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...