Database Mirroring ensures availability of SQL Server database in scenarios of data disasters. It is implemented in SQL databases that use Full Recovery model. It
Category: Database Mirroring
Mirroring FAQ
I plan to update this as I run across questions; I really like mirroring. Comparing to Clustering it is cheaper to setup also. I like
Mirroring Scripts
When I setup mirroring between servers on SQL Server 2005 I use following scripts: SQL2K5MirroringScript-MirrorServer.sql SQL2K5MirroringScript-PrincipleServer.sql SQL2K5MirroringScript-WitnessServer.sql These scripts rely are designed and rely on
Database Mirroring: Fully Quanlified Domain Name (FQDN) Error
If you are trying to setup Database Mirroring, it prefers to see a FQDN for the servers when entering partner information. If you don’t you’ll
WIP: Mirroring Issues
We have a SQL Server 2005 EE 64x mirror enviornment set up; but even though the SQL Servers looks like they are performing their duties
SQL Canada (SQLCAN) 