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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|