469,088 Members | 1,268 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

Database off line; How do I detect with a query

How do I detect with a query which database is off-line.
And how do I detect with a query the recovery model of a database.

Bye

Arno de Jong
Jul 20 '05 #1
2 2655
EXEC sp_helpdb

See "Status=" and "Recovery=" in the Status column.

--
David Portas
------------
Please reply only to the newsgroup
--
Jul 20 '05 #2

"A.M. de Jong" <ar****@wxs.nl> wrote in message
news:bo**********@reader10.wxs.nl...
How do I detect with a query which database is off-line.
And how do I detect with a query the recovery model of a database.

Bye

Arno de Jong


select databasepropertyex('MyDB', 'Status')
select databasepropertyex('MyDB', 'Recovery')

Simon
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Sheldon Glickler | last post: by
9 posts views Thread by Jerim79 | last post: by
10 posts views Thread by ircmaxell | last post: by
9 posts views Thread by =?Utf-8?B?TUNN?= | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.