all groups > sql server clustering > october 2007 > threads for october 8 - 14, 2007
Filter by week: 1 2 3 4 5
SQL 2000 - Win 2003 Enterprise and Clusters
Posted by Kevin A at 10/13/2007 12:38:28 PM
In a nutshell, all I want to know is:
On an active/passive cluster (2003 enterprise)
Should I install one SQL 2000 enterprise as a virtual and the 2nd as an
Instance, or can I install both as Virtuals? (Each having it's own name and
IP on the same active node?)
... more >>
Same instance name in cluster ?
Posted by JP at 10/12/2007 6:34:01 PM
Hello,
I explain, I will have a 3 nodes cluster, all nodes will host 1 instance,
but I need that 2 of them get the same instance name. during the setup it
refuse, I don't understand why as each instance will have it's own virtual
server and the path will be different SERVERA\INS1 and SERVER... more >>
Cluster versus none cluster
Posted by Jacques Demers at 10/11/2007 2:37:25 PM
Hi,
I have a question concerning clustering SQL 2005. Let's say that you
installed SQL Server 2005 on a machine with no clustering and you want to
enable clustering do you have to reinstalled SQL server completely?
Thanks
Jacques
... more >>
MSDTC only works on one node at a time?
Posted by Brian Brian at 10/11/2007 1:26:01 PM
We have a two-node active/active sql cluster (sql 2005 and windows 2003 EE
64bit), and we configured MSDTC in one resource group running on one node. It
seems that only the SQL instance that is running on the same node which MSDTC
is running can use distributed transactions. Is there any way t... more >>
64-bit SQL2005 SP2 Fails on cluster install
Posted by Michael Kuzminski at 10/11/2007 12:26:01 PM
I have two nodes (active/passive) in my cluster that I am trying to upgrade
from 64-bit SQL 2005 SP1 to SP2. I followed Microsoft's instructions and
logged into the active node with Admin Privleages. However, the setup keeps
failing when attempting to upgrade the Database Services.
It says:... more >>
how settings change affect current running services
Posted by Bill at 10/11/2007 7:13:03 AM
Hello,
If I change cluster failover/failback settings will that affect any current
running services? Specifically I want to change the resource setting to "Do
not Restart". If I change that will it affect the currently running SQL
services? I don't want to initiate the restart of any pro... more >>
Migrate WSUS to SQL Server
Posted by Ricky at 10/10/2007 11:54:46 PM
Hi
I have WSUS v.2.0 in a windows 2000 server with msde and I want to know if
it is possible to migrate only the database of WSUS from MSDE to a server
with windows 2003/sql server 2000 or 2005 depending if exists any kind of
incompability.
Can someone help me on this issue and explain m... more >>
Newbie question
Posted by coady at 10/10/2007 10:30:03 AM
Hi,
Just about to set up SQL 2005 cluster. Do I need to set up Windows cluster
environment, then set up SQL 2005 cluster?
Thank you... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
irpstacksize error message
Posted by Paul at 10/10/2007 10:24:02 AM
I have a few shares setup on my SQL 2005 Cluster and when a user tries to
connect to a share I get an error message. Has anyone seen this I have
changed the registry setting to 15 but I am still getting the error message.
The KB225782 says this fix applies to NT 4.0 not Windows 2003. I am go... more >>
Cluster Groups & Quorum
Posted by Paul at 10/9/2007 6:40:01 PM
I have a 2 node SQL 2005 cluster. I have a few questions about the Quorum
resources. When I setup the cluster I pointed the vitural server quorum
resource to a local disk. (Q:\MSCS). I feel like I did not set this up
correctly. The 4 Resources types I have in the First Resourece group is. ... more >>
SQL 2005 Cluster Maintenance
Posted by Daniel at 10/9/2007 8:49:06 AM
We are currently planning for two-node SQL 2005 cluster for some of our
applications. We are hearing that SQL 2005 cluster doesn't handle being
patched with MS hotfixes well. It probably matters what kind of hotfix is
being applied but does anybody know what is the best procedure/practice for... more >>
Integration services. High availability configuration
Posted by Abel at 10/9/2007 2:47:00 AM
Microsoft said that not recommend that the Integration Services service be
configured as a cluster resource.
(http://msdn2.microsoft.com/en-us/library/ms345193.aspx)
What is the recomended configuration to have Integration Services in a high
availability environment?
Thanks.... more >>
Error installing either SP1 or SP2. Error number 28017.
Posted by Patriot at 10/8/2007 10:02:02 AM
The MS Cluster install went well, the SQL 2005 went great as well. No errors
at all...that was until I tried to install SP1 then tried installing SP2. I
get the same error every time. It has to do with a recent install of KB
921896. The error on the summary.txt file is 28017.
I though may... more >>
|