SQL Server 2008 – Find If A Database Is Offline With T-SQL

On March 3, 2009 · 1 Comment

In SQL Server 2008 you can find if a database is online of offline by querying databases system view. A simple query such as this one gives me a list of all databases on my server and the second column shows if the database is online or offline. 

SELECT Name, state_desc
FROM sys.databases

image

On my server I have a database called LinqToSqlLab which is currently offline.

Tagged with:
 

One Response to SQL Server 2008 – Find If A Database Is Offline With T-SQL

  1. Luke says:
    October 12, 2011 at 2:55 pm

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>