I've got a Disaster Recovery plan for SQL 2000 that I'm trying to modify to
work with SQL 2005.

Currently, I've built a test server (same OS build, same SQL 2005 build,
same computer name, same IP address as the production server). I restored
the database backups to the test server. I have (i think) successfully
restored the Master, MSDB, and model databases.

My user databases all appear in SQL Server Management Studio, but they don't
show as "suspect" the way they do in SQL 2000, and when I right-click and
select "Tasks", the only options available are: Detach, Take Offline, Mirror,
Launch Database Mirroring Monitor, Ship Transaction Logs, Generate Scripts,
Copy Database.

Of course, the databases are not accessable, because they don't really
exist. What can I do to restore my user databases? Or what did I do wrong
to get myself in this pickle?

> What can I do to restore my user databases?

Use the RESTORE command from a query window.


> Or what did I do wrong
> to get myself in this pickle?

There's nothing wrong here. The 2005 tool behaves a bit differently from the 2000 tools, quite
simply...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"John Trask" <JohnTrask@discussions.microsoft.com> wrote in message
news:7CFD4DAA-1801-464F-9815-59E264CB1553@microsoft.com...
> I've got a Disaster Recovery plan for SQL 2000 that I'm trying to modify to
> work with SQL 2005.
>
> Currently, I've built a test server (same OS build, same SQL 2005 build,
> same computer name, same IP address as the production server). I restored
> the database backups to the test server. I have (i think) successfully
> restored the Master, MSDB, and model databases.
>
> My user databases all appear in SQL Server Management Studio, but they don't
> show as "suspect" the way they do in SQL 2000, and when I right-click and
> select "Tasks", the only options available are: Detach, Take Offline, Mirror,
> Launch Database Mirroring Monitor, Ship Transaction Logs, Generate Scripts,
> Copy Database.
>
> Of course, the databases are not accessable, because they don't really
> exist. What can I do to restore my user databases? Or what did I do wrong
> to get myself in this pickle?