Thursday, February 17, 2011

How to apply Cumulative update package for SQL Server 2005/2008 on Mirror Databases

1. Take backup of all dbs in Principal Server


2. Pause Mirroring on Principal Server for all mirrored dbs

3. The Principal server databases becomes (Principal,Suspended)

3. Stop all SQL services on Mirror Server (Including WMI service)

4. Apply CU patch on mirrored servers

5. Unpause Mirrors (wait for them to catch up)

6. Failover the databases (the Mirror server becomes Principal server)

7. Pause Mirroring

8. Hand-over to Application users to test and wait for their confirmation to proceed.

9. Stop all SQL services on Mirror Server (Including WMI service)

10. Apply CU patch on Principal servers

11. Unpause mirrrors

12. Failback databases.

Wednesday, February 09, 2011

Proven SQL Server Architectures for High Availability and Disaster Recovery

Proven SQL Server Architectures for High Availability and Disaster Recovery

If you are looking for your organisation to implement High Availability and Disaster Recovery for SQL Server R2. Please read Paul S. Randal wrote this white paper. You can get it from the following url.
Paul S. Randal (SQLskills.com)

Wednesday, February 02, 2011

SQL Server default listening port 1433

Please make sure that SQL Server running on default listiening port is 1433.
For the security reason you can change port 1433 to other numbers to protect your servers.