How to Bring out Database from suspend mode to Nor

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

SQL Server 2000 Forums

SQL Server Administration (2000)

How to Bring out Database from suspend mode to Nor

Author

Topic

saivyshnav
Starting Member

17 Posts

Posted - 2007-01-29 : 12:37:18

Hi all

How to Bring out Database from suspend mode to Normal?

Can some guide me

saivyshnav
Junior DBA

nr
SQLTeam MVY

12543 Posts

Posted - 2007-01-29 : 13:11:05

Why is it suspended?
see
http://www.nigelrivett.net/SQLAdmin/RecoverCorruptDatabase.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-29 : 15:17:30

What is "Suspend mode"?

Do you mean Suspect, Standby, Offline, Recovering, Restoring, Read Only, DBO Only, or something else?

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources