Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server clustering > january 2004 > threads for january 1 - 7, 2004

Filter by week: 1 2 3 4 5

Error 14258
Posted by Jenny at 1/7/2004 11:29:13 AM
Hi, Our Cluster Server had problems last week. Once it's up, the SQL Server Agent shows running. But when I double click the jobs, all jobs show Microsoft SQL-DMO (ODBC SQL State: 42000) Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later. I c...more >>

Cluster Monitoring Questions
Posted by Brian at 1/7/2004 8:01:22 AM
Hi Gurus I am going to take over a SQL 2k cluster with Win 2k on Compaq SA (active/passive). I would like to know if there is any difference as regard to the monitoring of CPU, Disk and Memory etc.? Can I use window performance monitor as I usually do with standalone SQL 2k installations any t...more >>

Clustered Analysis Server
Posted by Bjorn Mobak at 1/7/2004 4:04:20 AM
Hi. I'm thinking about installing Analysis Server (2000) on Windows Server 2003 (2-node). Any known problems that I should be aware of? Thanks in advance. Bjorn...more >>

sql 2000 setup on 2003 cluster
Posted by David Hogarth at 1/7/2004 12:22:01 AM
Hi I am trying to install Sql 2000 Ent on a distributed 2003 cluster (majority node). I have setup the cluster disks and MSDTC. The install stops responding after the virtual IP page when it starts looking for the disk groups. I have tried the Name pipe work around (Q815431) but no luc...more >>

SQL Cluster SQL SP3a install fails
Posted by chris at 1/6/2004 2:15:21 PM
We have an active-passive MSCS Sql cluster. The systems are running MS Win2k SP3. We are currently at MS SQL SP1. I try to install SQL SP3a and it seems to go ok and after a long wait and it seems near the very end I get an error stating installation failed. Any ideas or help would be apprecia...more >>

Truncate SQL Server Error Log
Posted by Dan at 1/6/2004 10:43:29 AM
I have a SQL Server 2000 Clustered server that has not been rebooted in several months and the error log is approximately 1.5 MB in size. It takes several minutes to refresh the error log. What is the best practice to eliminate last month's data from the error log? Thank You, Dan...more >>

SQL clustered with Exchange
Posted by Coll Campbell at 1/6/2004 9:11:16 AM
I am new to trying to run a cluster. I need to know if I can cluster Exchange 2000 along with SQL 2000 such that they both run on an active box with a shared standy server (2 Servers, all running on A, both failover to B) can I run two servers, one with Exchange and one with SQL such that if either...more >>

How to Add Local Physical Disk to Single-Node Cluster?
Posted by michael [multnomah] at 1/5/2004 6:47:51 PM
Hello. We have SQL Server 2000 running on a Single-Node Cluster for a Development server on Windows 2003 EE. We are running a local Quorum on the C: [OS] drive. We want to add two local Physical Disks as Resources under our SQL Server Cluster group. The addition of the Physical Disk Reso...more >>



failover results in SQL resource on NodeA, CLUSTER resource on NodeB
Posted by moblex at 1/5/2004 5:21:20 PM
I run a SQL2k/win2k adv active/passive 2 node cluster If I manually failover the cluster both the SQL resource group and the CLUSTER resource group move to the passive node without incident. Recently we had a network hiccup that triggered the failover process. The result has the CLUSTER resource...more >>

NLB & SQL Clustering over a VPN
Posted by SizzleMaster at 1/5/2004 3:41:23 PM
I need to setup NLB & SQL Clustering for a SharePoint farm deployment. I was wondering if this is possible if the servers are connected to one another via a VPN connection? If it is possible, are there any special considerations that I must be aware of? Thanks for ANY help. ...more >>

G
Posted by Installing MDAC on a cluster at 1/5/2004 2:50:07 PM
Hi All Do you install MDAC 2.8 on each node seperately or is there a "cluster installation" for MDAC where it automatically installs it over the nodes? Thanks G...more >>

SQL Clustering and Named Pipes
Posted by Alex at 1/5/2004 2:18:53 PM
Hi, I need to disable named pipes in a SQL Cluster environment (Windows 2000 and SQL 2000 latest SP). Here is the scenario: Our security policy requires me to secure my production SQL Server (Virtual SQL Cluster name=SQL01) by disabling any access to SQL Server except access from applicati...more >>

Microsoft updates on cluster servers
Posted by Andrew Brown at 1/5/2004 7:27:51 AM
Does anyone know if there is any special process required when updating SQL cluster servers ?...more >>

Heartbeat ip change
Posted by encrypted6966 NO[at]SPAM yahoo.com at 1/2/2004 7:58:55 AM
I have a windows 2000 server that runs SQL 2000 Etr. I need to change the ip address of the heartbeat. I was wondering what the best way to change that would be. Thanks for your time...more >>


DevelopmentNow Blog