Can't Restore DB - Select Devices doesn't respond 1

[clint6]

When trying to restore a DB in SQL 2000, it takes a while for the restore menu to come up. When it finally does, I choose the "from device" radio button. I then click on "select devices" to choose my file and I don't get a response.

We have plenty of free space available. Has anyone ran into a similar issue?

Thanks
Clint

 

[mrdenny]

Do you have any backup devices defined on the server?

The restore database GUI queries data from the MSDB database. If there is a lot of backup data (do to lots of backups) then this GUI will take quite a while to respond.

It's usually easier to use a T/SQL command to restore the database. Look up the RESTORE DATABASE command in BOL for the full syntax.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[clint6]

Thanks

I was able to restore the DB through the analyzer.