Browse by Tags

SQL Server 2005 Multi-Site Clustering with Windows Server 2008

Published 2 November 8 10:20 AM | SqlServer-QA.net

I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build...

Filed under: sql server, high availability, 2008, clustering, 2005

Install cumulative update package 7 on a SQL Server Cluster?

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

IN continuation to the post Rollback_of_CumulativeUpdate-hotfix-ServicePack I was asked about any procedure or steps on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on Active node SQL 2005 cluster. The simple answer is all...

Filed under: sql server, best practices, hotfix, clustering, uninstall, cumulative update, css

Support Webcast: Microsoft SQL Server 2005 Failover Clustering on Windows Server 2008

Published 19 May 8 2:53 PM | SSQA.net

A new Level 300 support webcast has been scheduled for Monday the 9th of June, 10:00 AM Pacific Time. The summary of the session is as follows: This Support WebCast focuses on how to plan, implement, and administer a Microsoft SQL Server 2005 failover...

Filed under: sql server, windows, 2008, clustering, 2005

SQL Server 2005 Failover Clustering on Windows Server 2008 - webcast

Published 16 May 8 9:13 PM | SSQA.net

Windows Server 2008 is on full fledged wave now after it has been launched in February and it is obvious that many questions will be flying around about supportability & manageability for existing SQL Server versions such as 2005 at the moment. Think...

Filed under: sql server, best practices, clustering, failover, windows 2008, new features

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Published 18 March 8 4:20 AM | SSQA.net

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability

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

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

Published 29 February 8 4:4 AM | SSQA.net

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the...

Filed under: sql server, performance, blogs, environment, clustered, clustering, san, best practice, monitoring, benchmarking

A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005

Published 10 February 8 1:7 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications A service pack does not install on a x64-based passive node cluster computer...

Filed under: sql server, kba, x64, clustering, service pack, passive node

SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

Published 22 January 8 7:55 AM | SSQA.net

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that...

Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail

All about SQL Server with 32bit to 64bit cluster migration - steps to take care

Published 15 January 8 2:44 AM | SSQA.net

An interesting cross-post from SSP Blog - read thisblog for more information....( read more ) Read More...

Filed under: sql server, upgrade, best practices, environment, clustering, ssp, 32 bit, 64 bit, forum

The DHCP support is not available when you install SQL Server 2005 on a Windows Server 2008 failover cluster

Published 2 January 8 1:4 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications The DHCP support is not available when you install...

Filed under: sql server, kba, longhorn, clustering, network, failover, windows 2008, dhcp

BUG: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> been patched with more recent updates"

Published 12 November 7 4:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications BUG: Error message when you try to install...

Filed under: sql server, kba, bug, service pack2, clustering, active node, patches

SQL Server MSDTC service - do you need it or not?

Published 11 October 7 7:2 AM | SSQA.net

MSDTC - Microsoft Distributed Transaction Coordinator should be installed (Service up and running) when executing the BEGIN DISTRIBUTED TRANSACTION statement that controls the completion of the transaction. So to complete this transaction with a subsequent...

Filed under: sql server, services, kba, transaction, clustering, msdtc, servers, end, begin

Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service

Published 9 October 7 2:50 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Description of the SQL Server Integration...

Filed under: sql server, ssis, services, kba, clustering, servers, integration services

SQL Server 2000 and SQL Server 2005 support for mounted volumes

Published 5 October 7 7:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications SQL Server 2000 and SQL Server 2005 support...

Filed under: sql server, kba, standard, 2000, storage, clustering, 2005, mounted, volume

FIX: Event ID: 21421 occurs when you use the Microsoft Operations Manager 2005 agent to monitor a clustered instance of SQL Server 2005 in a clustered environment

Published 19 September 7 11:57 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, clustering, operations manager, 21421, mom

Clustered SQL Server do's, don'ts, and basic warnings

Published 15 September 7 6:10 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Clustered SQL Server do's, don'ts...

Filed under: sql server, kba, clustering, advice, warnings, do, don't

Whats the best way to setup memory on a four-node cluster?

Published 6 September 7 4:42 AM | SSQA.net

Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances...

Filed under: sql server, performance, analysis, high availability, ssis, security, ssas, ssms, clustering, resources

Information and issues with Kerberos security within SQL Server 2005?

Published 31 August 7 4:45 AM | SSQA.net

What is the Kerberos Authentication? What are the security features difference between Windows 2000 and 2003 versions? How it is behaved within Failover Clustering? How to enable Kerberos Authentication Including SQL Server Virtual Servers on Server Clusters...

Filed under: sql server, security, windows, audit, clustering, authentication, failover, kerberos

How to change the network IP addresses of SQL Server failover cluster instances

Published 29 August 7 2:56 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to change the network IP addresses of SQL Server failover cluster instances http...

Filed under: sql server, kba, connections, clustering, network, failover