Friday, March 9, 2012

Query to find dbs that are log shipped

I need to find out all the dbs that are currently in readonly/standby state
on my standby servers. These databases are log shipped with standby option
ThanksCheck out the DATABASEPROPERTY() and DATABASEPROPERTYEX() functions.
--
Tibor Karaszi
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23jgPwn8oDHA.424@.TK2MSFTNGP10.phx.gbl...
> I need to find out all the dbs that are currently in readonly/standby
state
> on my standby servers. These databases are log shipped with standby option
> Thanks
>

1 comment:

Blogger said...

Are you trying to make cash from your visitors using popunder advertisments?
In case you are, did you try using Clickadu?

Post a Comment