Browse by Tags

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

Published 8 May 8 3:42 AM | SSQA.net

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

Log Shipping error "Unable to copy the initialization file"

Published 3 October 7 6:49 AM | SSQA.net

When configuring log shipping on a highly transactional environment (with SQL Clustering setup), we were hit by above error. All the Logins and their privileges are intact within the primary and standby servers along with Local server policies & group...

Filed under: sql server, high availability, server, login, cluster, log shipping, service account, firewall, unable, filecopy

Extending MSCS Cluster High Availability Offsite

Published 19 June 7 1:2 PM | SSQA.net

MSCS clustering can be a good option for local high availability - but it doesn't provide complete protection from unplanned downtime. Download this free white paper and learn how extending your MSCS cluster offsite with a high availability solution...

Filed under: sql server, high availability, cluster, offsite