find high availability configure in SQL server 2008 R2

• yuvipoy

  SSChampion

  Points: 10469

  More actions

  September 19, 2016 at 11:55 pm

  #313689

  Hi,

  How to find what high availability SQL server 2008 R2 has been set up?

  Like is my server is configured with Clustering or with Replication or with Mirroring or with Log shipping via Query instead of looking into IDE.

  How can we find those.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  September 20, 2016 at 11:32 am

  #1901977

  You can execute things such as:

  select SERVERPROPERTY('IsClustered ')

  exec master..sp_help_log_shipping_monitor

  select *

  from sys.databases

  select *

  from sys.database_mirroring

  Sue