SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc
Read More...
IN the case of production server which is running 24/7 and can't afford any downtime, it is good to keep the mirrored server for reporting purpose. Say if the requriement is to have r eporting server that should be updated with data from production server
Read More...
What happens to the Replication when the SQL instance failover to the mirroring server as it is involved in Database Mirroring session? Choosing Transactional Replication is best choice in the setup of Database Mirroring if you would like to provide such
Read More...