Restore database to another server?
jason.williams14
Posts: 5
Hello everyone.
I am pretty new to red gate products but have a question.
First, I am pretty sure I bought Backup PRO,but is there a way to verify?
Secondly, is it possible to restore a backup of one database to another server?
This is something I would like to test as part of our monthly maintenance. We like to do test restores every month to ensure our backups work and the data is ok.
I appreciate it.
_Jason
I am pretty new to red gate products but have a question.
First, I am pretty sure I bought Backup PRO,but is there a way to verify?
Secondly, is it possible to restore a backup of one database to another server?
This is something I would like to test as part of our monthly maintenance. We like to do test restores every month to ensure our backups work and the data is ok.
I appreciate it.
_Jason
Comments
if you have a licence for both servers it is not difficult. You can use the GUI to look at the .sqb backup and go thru the screens specifying if this is a new database and wehere you want to put the DB files and what you want them called. If you only have one licence then there is a utility to take a Red gate backup and convert it to the native SQL backup.
HTH
Chris