What are the challenges you face when working across database platforms? Take the survey
Options

Restore database to another server?

jason.williams14jason.williams14 Posts: 5
edited January 15, 2009 10:20AM in SQL Backup Previous Versions
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

Comments

  • Options
    Jason,

    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
    English DBA living in CANADA
Sign In or Register to comment.