Browse by Tags

• database
• geographic
• mirror
• performance
• principal
• server
• SQL Server
• tsql
• witness
• x64

• Number of databases limit for Database Mirroring within X64 environment?

  We have had a request from one of the solutions company stating they have to mirror 15 SQL Servers that are dispersed across the European locations to a central location. For this they have deployed the X64 environment for operating system and SQL Server Read More... Posted Thursday, August 30, 2007 8:27 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, x64, server, database mirroring, high availability, geographic

• Get basic Database Mirroring information- principal or mirror

  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... Posted Monday, August 20, 2007 8:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, tsql, database, database mirroring, principal, high availability, witness, mirror