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 > april 2004 > threads for april 22 - 28, 2004

Filter by week: 1 2 3 4 5

Restore fails - LOADING state
Posted by Jim Trowbridge at 4/28/2004 12:46:10 PM
We run a two node cluster, with all resources currently on one node. The server is working no problems - but.. We try to restore a backup and it completes, but leaves the database in LOADING status, without doing anything We have had this failure when the cluster is not all on one node, we have t...more >>


Regarding Active-Active Cluster
Posted by Harsha at 4/28/2004 11:51:33 AM
Is their any document avaiable on Active-Active SQL cluster on microsoft site. If yes can some one please send the link...more >>

Adding Spindals on Cluster to SAN
Posted by Dave at 4/28/2004 11:41:04 AM
How much work is it to add spindals to a drive on a Windows 2000 Advanced Server clustered on a SAN? Thank You, Dave...more >>

Backup Distribution Database
Posted by Mike at 4/28/2004 11:36:30 AM
Should a distribution be backup? Thank You, Mike...more >>

how many clusters can i set up ?
Posted by Hassan at 4/28/2004 9:28:25 AM
A slight confusion. I have created a windows cluster with 2 nodes and a single instance of SQL 2K cluster Is it possible to create many windows clusters? I was looking at the Cluster Admin and there is an option to create a new cluster ... Why would one want to do that especially with only 2 n...more >>

Service
Posted by Bob at 4/28/2004 7:10:34 AM
Folks, My question is what should the SQL service and SQL agent service be set at. Should it be set to start automatically or manually? Thanks, B ...more >>

SQL 2005 (Yukon) question
Posted by KA Kueh at 4/27/2004 9:46:33 PM
Dear all, Does anyone know if the next version of SQL will support load-balancing as well as fail-over clustering? Thanks. Regards, Kueh. ...more >>

Multi Instance Cluster Question
Posted by Ronald at 4/27/2004 3:42:09 PM
I decided to try and setup a multi instance cluster on my own and seem to be fairly successful . Its SQL 2000 EE on Windows Server 2003 EE Just had 2 questions. When i installed the second instance, it asked me for a virtual name.. so i gave it one ..in my case SQL2.. and then was asked f...more >>



Need Help for installing and configure SQL cluster
Posted by Sameer Prabhune at 4/27/2004 1:51:02 AM
I am trying to install an Active/passive cluster of SQL 2000 on a Win2003 machine. Can any one give me details stapes how to configure it same and what are the procedure I have to follow I can firm windows cluster properly but do I have to install SQL server on all cluster nodes or no need for sam...more >>

Exchange cluster
Posted by IFreyre at 4/26/2004 7:35:19 PM
Dont know clusters, just starting to look into them. I do, however, have needs for fault tolarance. Starting with our email server. Sounds to me that Clustering is a bit over kill for an Exchange server or 12gig database to be useing as a fail over system. I'm i correct in making this assump...more >>

Active/Active Cluster
Posted by BeerBoy at 4/26/2004 9:46:04 AM
I am trying to install an Active/Active cluster of SQL2000 on a Win2003 machine. I installed the default instance and a named instance. When both instances are on the same machine, they come up correctly. However, if I fail the named instance over to the other node, it will not come up. If I then f...more >>

Unable to view drives
Posted by Theo Jones at 4/26/2004 9:34:31 AM
We are working with a Windows Server 2003/SQL 2000 cluster. We have split our SAN volumes into three separate drives. From Enterprise Manager, we are only able to view one drive, which is the SAN drive the SQL system data was installed. We tried going through creating a new database, ba...more >>

Scenario
Posted by Johan at 4/23/2004 7:02:39 PM
Consider the following scenario: I got 2 webservers (2003) using NLB. I want some kind of common data store (SQL Server). I need this data store to be fault tolerant. I don't have any more machines. I don't have an enterprise licence for windows. How do I solve this??? ...more >>

Unistall/Reinstall of Cluster Services
Posted by John Hubbard at 4/23/2004 1:56:41 PM
I have a need to unistall cluster services. This is on a Win2ksp4 server with Sqlserver2ksp3. Currently only one side of the cluster is setup. No failover server is configured at this point. I am testing on a sandbox server. After having all the software installed and working, I uninstalled clu...more >>

Failover Issue
Posted by Dylin Mikals at 4/23/2004 9:42:57 AM
I am setting up an Active/Active cluster with one instance of SQL in each node. When I am failing over from one node to the other, the SQL Server, SQL Server Agent, and SQL Server Fulltext do not come online. The state is listed as Online Pending. The physical disks, SQL IP Address an...more >>

Active/Active ClusterInstall
Posted by John Wang at 4/23/2004 9:36:27 AM
How do you install SQL server in Active/Active cluster? We want have an instance of SQL running on each of two nodes. What different when installing it like this versus Active/Passive? Thank....more >>

Cluster with 1 server ok second not
Posted by Colemont Bert at 4/22/2004 11:28:07 AM
Hi all, The problem that we have: We have a SQL cluster which contains 2 windows Adv servers, server X and Y Y is the primary node, and on that node is a virtual SQL installed, X is the secondary node, but it needs to be reïnstalled, as there is a db running on the cluster, I wonder if it w...more >>

act/pass cluster upg from geerhead...
Posted by wadeing in vain at 4/22/2004 10:02:54 AM
following up on the geerhead message: first, uncluster the SQL then reboot node1 second, upg the sql 7 to sql 2000 third, upg the sql 2k to sql 2000 cluster instance... OK...are there any upgrades to node2? Or will thw sql 2k cluster instance take care of that? ...more >>


DevelopmentNow Blog