determining database state 1

[monkeylizard]

I have a DB that I have gotten a good backup of. This DB is used for training. I want to give the trainers the ability to restore the backup and effectively restore them to their pre class session state.

I've written an app that executes a restore command when they click a button. I want to make the app wait until the restore is done before returning a "It's done" message.

My problem is that I don't knwo how to determine if a database is in ready mode or still restoring.

I've found master..sysdatabases and it has a "status" column, but I don't know how to find the meaning of the number in this column, or if it's relevant.

Is there a stored proc that can be called to return database statuses? If not, can I join sysdatabases somewhere to get the status?

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

 

[gmmastros]

Read this... it should help.

http://www.sqlservercentral.com/Forums/Topic150618-5-1.aspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[monkeylizard]

Thank you. have a star!

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

 

[mrdenny]

If the SQL command is still running then the restore is still running. Once the SQL command running then RESTORE DATABASE is complete the database is available.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog