how to tell if db is in standby 1

[k108]

Hi,

Is there a sql statement you can run to determine if a particular database is in standby mode?

Thanks

p.s. I notice that I am able to run certain queries against my standby database. What can and can you *not* do if a database is in standby?

 

[mutley1]

Hi K108,

If you are using query analyser, run

sp_helpdb

and that will return the status of all databases on the server. If you want to look at a particular one just enter the database name after sp_helpdb

sp_helpdb YOURDB

M.

 

[k108]

Yes, I use the sp_helpdb command a lot. Unfortunately, it does not tell you if a database is in standby mode.

 

[JamesLean]

Use this:

SELECT DATABASEPROPERTYEX('mydb', 'IsInStandBy')

--James