Database Mirroring Sync type (Operating Mode)

select DB_NAME(database_id) dbname,CASE mirroring_safety_level WHEN 0 THEN 'Unknown' WHEN 1 THEN'asynchronous' WHEN 2 THEN 'synchronous' END from sys.database_mirroring

image

Leave a Reply

Your email address will not be published. Required fields are marked *