Post reply

Check if database is running in mirroring mode?

  • October 28, 2008 at 4:42 am

    #195142

    Hi, is it possible in T-SQL to check if a database is running in mirroring mode? Maybe there is some system SP that can tell me, but I haven't found one yet.

    The reason for looking it up is that a script I have is changing the recovery model of the database in a batch operation but shouldn't if the database is running in mirroring mode.

    Any ideas?

  • October 28, 2008 at 6:56 am

    #890580

    michael (10/28/2008)

    Hi, is it possible in T-SQL to check if a database is running in mirroring mode? Maybe there is some system SP that can tell me, but I haven't found one yet.

    The reason for looking it up is that a script I have is changing the recovery model of the database in a batch operation but shouldn't if the database is running in mirroring mode.

    Any ideas?

    I admit that I didn’t work yet with mirroring, but the first thing that I would check is querying sys.database_mirroring DMV

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • October 28, 2008 at 9:40 am

    #890736

    Thanks for the help, that table contained the details I needed 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply