471,873 Members | 2,018 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

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 2691
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 YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.