hortonm 0 Report post Posted April 4, 2006 Hello, I was just wondering what options I need to select to perform a test restore of an active database? When I perform the restore, I don't want to copy over the database I am backing up, I'd like to restore to anothe location on the SQL server. Is this possible? My SQL knowledge is limited, but I am the backup admin for our company... Thanks, Mike Share this post Link to post Share on other sites
nembot 0 Report post Posted April 10, 2006 Hi, Yes you could create a new database in SQL and restore in that new database but be aware that you have some personal problem by confusing table names in the new database with the ones in use. Thanks, Share this post Link to post Share on other sites
Mayoff 124 Report post Posted April 10, 2006 Retrospect has an option to Restore the database to a new name. Restoring the database to a new name should have no impact on the other databases on the server. Share this post Link to post Share on other sites