Mounting a database - SQL Server Forums

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

Mounting a database

Author

Topic

vaddi
Posting Yak Master

145 Posts

Posted - 2007-03-16 : 19:09:06

Hello

How can I mount a database in sql server 2000. I was not able to take offline.I am not sure..what happened to the db , it shows me suspect for that.

What can I do to bring that database online.

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-03-17 : 02:44:01

I hope you mean ATTACH, not mount...

Peter Larsson
Helsingborg, Sweden

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-17 : 11:12:29

You have to sp_attach_db procedure to attach (mount) the db...
Check the sql server error log to find the reason of database suspect.

MohammedU

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources