Setup: SQL Server 2005 w/SP4 64-bit Standard for all three servers Windows Server 2008 R2 Enterprise w/SP1 64-bit for all three servers 01 is designated as the Principal 02 is designated as the ...
Mirroring traffic looks normal but externally reported bandwidth of mirroring traffic is much higher
We have a live sql server in one location, running MS SQL Server 2005 Enterprise on Microsoft Windows Server 2008. We have a similar server in an alternative location (connected by vpn) serving as a ...
My company has a failover pair of SQL Server 2005 instances, which provide database availability for a UL-licensed alarm/call center, where uptime and availability are critical for life safety. ...
We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints. If I go into ...
I have two database servers Server1 and Server2, configured with mirroring. A single database, MirrorDB, is mirrored. There is another database on Server1 named OtherDB which is only present on ...
Must all db servers be running the exact same version to enable mirroring without a witness server? How about with a witness server in place?
I am in the process of creating a TEST environment for our SQL Server development staff. In production we have 3 SQL Servers, SQL01 contains several databases that are mirrored to SQL02. SQL03 ...
We have two production SQL Servers running SQL Server 2005 SP4 with cumulative update 3. Both servers run on physical machines that are identical. DELL PowerEdge R815 with 4 x 12 core CPUs and 512GB ...