hortonm Posted April 4, 2006 Report Share 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 Link to comment Share on other sites More sharing options...
nembot Posted April 10, 2006 Report Share 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, Link to comment Share on other sites More sharing options...
Mayoff Posted April 10, 2006 Report Share 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.