daniel1113 Posted August 25, 2008 Report Share Posted August 25, 2008 I have a full backup of a database that was hosted on a client machine. This past week, the client machine died, so I need to restore the database to another server. I released my Sql Server Agent license and applied it to a new install of MsSql on another client machine. However, when I traverse into my backup set and select the database to restore, the "retrieve" button is inactive. Any thoughts? Quote Link to comment Share on other sites More sharing options...
Mayoff Posted August 25, 2008 Report Share Posted August 25, 2008 Are you selecting the new SQL server as the destination? Are you able to browse the existing databases on the new server? Quote Link to comment Share on other sites More sharing options...
daniel1113 Posted August 25, 2008 Author Report Share Posted August 25, 2008 (edited) Mayoff, I am able to access the databases on the new Sql Server through Retrospect. However, I cannot even initiate the restore process to select the new destination. I assume that is one of the options presented in Retrospect when I select select the "retrieve" button, but the entire "retrieve" button is grayed out. Edited August 25, 2008 by Guest Quote Link to comment Share on other sites More sharing options...
Mayoff Posted August 25, 2008 Report Share Posted August 25, 2008 Are you going to Restore>Databases? What are your exact steps? Quote Link to comment Share on other sites More sharing options...
daniel1113 Posted August 25, 2008 Author Report Share Posted August 25, 2008 Mayoff, No, I was locating the database in my backup set snapshot and trying to restore from there, similar to my file backups. It's been so long since I've used the "Restore" option on the menu that I forgot it was there. However, "Restore>Databases" worked like a charm. As usual, I was so involved with what I was doing that I missed the obvious. Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.