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

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

Get SQL Server Clustering information with DMVs and SELECT statements

Published 11 March 8 12:16 PM | SSQA.net

Few counters and gotchas for you to look for when you are installing SQL Server clusters, also using SELECT statements & DMVs to get SQL instance information. Such as: Do not install SQL Server on a compressed drive, by default the installation will...

Filed under: sql server, dmv, best practices, cluster, clustering, select, virtual server, nodes, shared drives, serverproperty

Error - There is not enough disk space on the destination disk, during a SQL Server failover cluster installation

Published 4 January 8 2:51 AM | SSQA.net

Had an interesting problem on one of the SANs that will be used to setup a failover clustering installation. The issue error "'There is not enough disk space on the destination disk for the current SQL server data files" and when I have...

Filed under: sql server, cluster, disk space, hardware, administrator, failover, errorr, installallation, not enough storage

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

Cluster resource 'SQL Server (<SQL Server instance name>)' in Resource Group '<Cluster group name>' failed.

Published 10 October 7 4:31 PM | SSQA.net

A common mistake by DBAs for missing to check whether all the functionality of tools are working when a SQL Server Cluster environment is setup, though you may not catch hold of few issues with basic failover/failback testing initially but when the application...

Filed under: sql server, dba, sqlagent, best practices, cluster, error log, online, failure, active/passive

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

Is it possible to run SQL Server 2000 and 2005 version on same cluster?

Published 10 August 7 7:3 AM | SSQA.net

Yes. This is supported as SQL Server 2005 and 2000 can be installed side by side on a cluster successfully. With regard to achieve this there should be more care on choosing the shared- disks & IP addresses with sensible resourced hardware. 1. Separate...

Filed under: sql server, cluster, 2000, 2005

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

Mount Points and Clustering blurb for SQL Server & windows operating system

Published 25 May 7 6:18 PM | SSQA.net

Mount Point is the new concept introduced in the Windows 2003 Server (R2) that works as a mounted drive is a volume or a drive that is mapped to a folder on a volume that uses the NTFS file system. Mounted drives function as any other volume or drive...

Filed under: sql server, security, disk, mount, shared, point, cluster