SQL Server not seeing databases

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server not seeing databases

Author

Topic

Carriolan
Starting Member

2 Posts

Posted - 2005-10-03 : 16:58:37

Hi
I have been a bit of an idiot. I was using MSDE. I de-installed it and installed SQL Server Developer Ed 2000. I then copied my MSDE databases to the SQL Server data folder, but the SQL SErver cannot see them. Can anybody tell me how to sort this out please.

Regards
Carriolan

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-10-03 : 17:09:45

you will have to use the sp_attach_db commands to bring them online.

here are the details: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

You can also use Enterprise Manger and select 'attach database' from the right mouse-click context menu.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources