Jump to content
Sign in to follow this  
daniel1113

Unable to Restore Database

Recommended Posts

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?

Share this post


Link to post
Share on other sites

Are you selecting the new SQL server as the destination?

 

Are you able to browse the existing databases on the new server?

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×