Opening a COPIED SQL Database 1

[RADAZ]

I copied a database from one file server to another file server (did NOT use Export option). When I open Enterprise Manager on the new server, I do not see how I can open that copy of the datbase. Is there a way to do this?

 

[RADAZ]

ADDITIONAL NOTES: The old server is no longer available, otherwise I'd go to it and do a BACKUP.

Thanks!

 

[SQLBill]

What do you mean you copied it? Did you detach it first and then copy the files? If not, then the files are most likely corrupt.

If you did copy them properly, did you move them to a server that has SQL Server on it? If so, do you have that SQL Server registered in Enterprise Manager? If so, all you need to do is right click on the server instance and select All Tasks>Attach Database.

-SQLBill

 

[SQLBill]

Ouch, we posted at the same time. But as a follow-up, at least try to attach the database as I explained (or you can do it via Query Analyzer and the sp_attach_db command).

Refer to the BOL for more information on attaching databases.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875