Browse by Tags

RSS Feeds

cluster (RSS)

SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.

At the first instance the error is clear that some problem with SQL resource that was allocated to the Cluster resource. Just a background on SQL Server Failover Clustering, that the server cluster consists of a failover cluster instance that runs under Cluster Services (MSCS). The instance of SQL Server...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 03-17-2010
Adding RAM to SQL Cluster Nodes - Procedure

Hi, My Sql Server 2k5 cluster has two nodes, both only have 2GB ram. I want to upgrade the ram of each host, and keep the cluster on-line. Is it safe to take one host offlince, uprgade it's ram, then bring it back up as part of the cluster, then repeat the process for the second host? Does SQL Server...

Posted to SQL Server 2005 Clustering (Forum) by subflux on 10-06-2009
moving quorum drive

I have a SQL Server 2005 active/passive cluster which has the quorum drive on a partitioned SAN LUN. I want to fix this and get the quorum drive on its own dedicated SAN LUN. What is the best way to move the quorum from the old LUN to the new LUN? Thanks in advance.

Posted to SQL Server 2005 Clustering (Forum) by mherfkens on 10-05-2009
showdown cluster database

Dear Sir, I'm young on cluster (windows 2003 Enterprise ,SQL server 2005) and I used MS.Virtual Server for my testing. Now I need to shutdown my cluster testing. I have 3 Server (Virtual Server) : MyDC, MyNode1 and MyNode2. Can you tell me, what I need to do when I need to shutdown all node on cluster...

Posted to SQL Server 2005 Clustering (Forum) by matineit on 09-02-2009
SQL Server 2008 installation issues: Access is denied

In general the installation of SQL Server is straight forward and should not be a problem unless the server is not under hardware/software configuration link here. As SQL Server 2008 version is designed secured by default and part of security measures within Windows operating systems (2003 & 2008...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 08-14-2009
SQL 2005 cluster best practices

Hello Everyone! My question would be: What are the best practices for configuring SQL cluster services and groups. Does it make sense to have only one cluster group for active\passive 2 nodes cluster with all the resources assigned to it, or create 2 cluster groups: SQL group and Cluster Group. Then...

Posted to SQL Server 2005 General DBA Questions (Forum) by sdavidchuk on 05-14-2009
SQL Cluster running at 97% memory utilization after Windows 2003 SP2 install

I know SQL 2000 is ancient history but we've just recently installed Windows 2003 SP2 on a SQL 2000 cluster (plus a firmware update and hot fixes). These servers have 32 GB available and SQL is configured with AWE enabled and max server memory (MB) of 30,720 MB. However, since the update, the monitoring...

Posted to Performance Tuning for Hardware Configurations (Forum) by SandraV on 04-27-2009
Active Directory domain group for cluster installation

For SQL Server cluster installation on SQL 2005 and SQL 2008 it requires to create a active directory Domain Group. The question here is, 1. Do we have to create the active directory domain group for each cluster instance? Can we share this account with other SQL Server cluster installation? 2. Does...

Posted to SQL Server 2008 Clustering (Forum) by sivasql on 04-17-2009
How to create a cluster for SQL Server 2005 on Windows Server 2003?

Hi, I need to test an application using SQL Server 2005 as source in a clustered environment. But I was unable to create a cluster on Windows Server 2003. Can anyone tell me how to create a cluster on Windows Server 2003? Also, is it possible to create a logical cluster on the same machine? If yes, what...

Posted to SQL Server 2005 Clustering (Forum) by ShivaniSuri on 03-04-2009
The operation could not be performed because OLEDB provider "SQLNCLI" for linked server "repl_distributor" was unable to begin a distributed transaction (Microsoft SQL Server, Error 7391)

The above error clearly specifies the connectivity issues between 2 instance, to give more information I have been dealing with this problem at a client's place. The setup that was configured and deployed was a very complicated replication between SQL Server 2005 version cluster as a publisher (out...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 02-11-2009