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 > october 2004 > threads for october 15 - 21, 2004

Filter by week: 1 2 3 4 5

How to move system databases to new SAN drive in cluster server?
Posted by Chen at 10/21/2004 1:53:03 PM
Hi, I have to move an entire SQL Server system databases from current basic drive W: to new SAN drive H: in cluster server (current is one node with two instances). During the installation, I put Program files to C: drive and Data Files to W: drive. After move all dbs, we will get rid of dr...more >>


SQL Server Cluster
Posted by Bob Mare at 10/21/2004 10:14:11 AM
Hi, I am presently running Windows 2003 cluster with SQL Server 2000. My question is what is the correct way to apply Critical Updates to a SQL Cluster? Thank you in advance for tour assistance! Bob ...more >>

Transactional replications to a server I plan to cluster
Posted by roustam NO[at]SPAM hotbox.ru at 10/21/2004 4:00:45 AM
Hi! I have a server I am planning to cluster. I will be using the same SQL server name for this cluster. I have a large number of transactional replications to this server from a dozen of other servers. Will these replications work evenly after the clustering? (All my servers are MS SQL200...more >>

SQL 2000 Installed on W2K3 Cluster
Posted by Derek at 10/19/2004 6:59:45 PM
Where can I find a complete step-by-step article on installing SQL 2000 Enterprise Edt. in a Windows 2003 Enterprise Edt.Cluster? We have purchased 2 Dell 6550 servers and a EMC CX300 fiber channel array. Dell is going to setup the cluster but I have to install the SQL 2000 server softwa...more >>

DTSRUN using MSDTC must run under Cluster Admin account?
Posted by micl NO[at]SPAM hkstar.com at 10/19/2004 6:46:58 PM
I have W2KAS, SQL Server 2000 active/passive cluster with cluster MSDTC resources. I use NT Task to execute DTS package via DTSRUN and package requires transactions. If the task is run as administrator or a account with cluster administrive right, everything is fine. Otherwise, I will get the...more >>

SQL Instance won't come online
Posted by Squerb at 10/19/2004 3:43:02 PM
Hi there, I have a two node cluster Win 2k with SP4 and SQL 2k with SP3. There are two instances of SQL. The primary instance comes up just fine. The secondary does not come up all of the disk, IP, and name resources load, but the SQL Server resource will not. I have been able to get it...more >>

URGENT: Active/Active Cluster and Replication?
Posted by C.Dimitrov at 10/19/2004 11:27:02 AM
Hi, We have one cluster with 2 virtual databases and name instances VDB01\DB1 and VDB02\DB2. They use different storage on a SAN. Machines are DL380s with 2 CPUs. OS: Windows 2003 Enterprise Server, SQL 2000SP3a. Now both of them have the same database Data1, Data2 and Data3 Existing scen...more >>

Replacing disk system in cluster environment.
Posted by Mikko Rantonen at 10/19/2004 10:58:31 AM
Hi! We are planning to replace our disk system in our SQL Server cluster environment. Our system consist of two cluster nodes and two SQL Server 2000 instances. There are only SQL Server database files including master database in this disk system we are replacing. Can we just shut down ...more >>



2003 web edition
Posted by Ed at 10/19/2004 2:55:04 AM
Is there a reason why the SQL 2000 installer would not be running on 2003 Web edition?...more >>

virtual device interface and clusters
Posted by Ray Mond at 10/18/2004 9:47:04 PM
How does one use the SQL virtual device interface (vdi) in a SQL Server cluster? The VDI connection command only accepts a parameter for instance name, not server\instance name. Thanks in advance. Regards Ray...more >>

SQL Server Named Instance Active/Active Cluster IIS TCP/IP Connection
Posted by tplumley NO[at]SPAM dvfs.com at 10/18/2004 2:34:19 PM
We have two active clustered sql servers and two separate IIS Load balanced servers. We can connect to both instances of sql server Enterprise manager and query analyzer (also tried an odbc connection) thru local pc's. I can get both IIS servers to connect to the default sql server instance us...more >>

question about failover
Posted by Reddi at 10/18/2004 9:57:03 AM
Hi, In MS Clustering the failover happens only at hardware level or it can also happen at application level? I mean If I am running two nodes, node1 & node 2. both these servers hardware has no issues but SQL server on node1 has some problem, will it be able to use SQL server on node2? ...more >>

Error Messages Cluster
Posted by Joe K. at 10/18/2004 9:09:06 AM
I have a Windows 2000 Advanced Server with SQL Server 2000 Cluster. There are only two nodes on this cluster. Two days ago I tried to move one of my resource groups to the other node. It failed each time I tried. I am presently in the WINNT\cluster.log file but there is only several ho...more >>

Cluster service fails
Posted by Chris at 10/17/2004 12:59:06 AM
I'm not able to start the cluster service on the 2nd node of our cluster. O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join the cluster but then it terminates unexpectedly. We've tried using the Administrator account to start the server, but with the same results. ...more >>

Installing a Second Instance
Posted by Beverley at 10/15/2004 8:11:02 AM
Hi, I'm trying to install a 2nd instance on a cluster. We've setup two cluster groups C101TC001 and C101TC002, one for each instance. I've stopped all the services and managed to get the installation to run, but it won't allow me to apply the Service Pack (3a). It reports an error An er...more >>


DevelopmentNow Blog