Monday, October 15, 2007

SQL Server Clustering vs. Database Mirroring

Server Cluster suits that all user and system databases should be fault-tolerant when a server has a failure. This cannot be achieved by Database Mirroring. Database Mirroring technology supports automatic fail-over when the database is offline. For database mirroring, you should manually copy all other user objects to the failover server.