all groups > sql server clustering > may 2004 > threads for may 1 - 7, 2004
Filter by week: 1 2 3 4 5
Can't get SQL 2000 installed on new node in Cluster
Posted by Pat Hall at 5/7/2004 2:26:07 PM
We can't get SQL 2000 to load on the new node (successfully added to the cluster). We are using the procedure How to add nodes to an existing virtual server (Setup)(from BOL). When asked for computer name we entered the SQL cluster name for the virtual server. When asked for the logon we used the... more >>
tempdb file placement on active/active
Posted by spee at 5/6/2004 9:56:03 PM
Given tempdb is recreated on startup is there any reason it must reside on a shared cluster resource
After installation to the shared resource (because other systemdbs will need to reside here), i would like to move tempdb to internal disk
Has anyone tried this? Or have any reference material th... more >>
MSDTC on Windows Server 2003
Posted by jf NO[at]SPAM uk.com at 5/6/2004 7:10:25 PM
I am running a sql server 2000 cluster on a windows server 2003
machine. Every time I try to install MSDTC it fails and this is what
is in the Event Viewer:
MS DTC setup failed to populate the shared cluster registry. The DTC
resource will not be able to come online.Error Specifics:
d:\n... more >>
Clustered Active/Active in Single-user mode
Posted by Moglia Michele at 5/6/2004 11:06:09 AM
What is the right procedure to start an instance of a clustered Active/Active Sql Server
The online-book unspecifically writes
From a command prompt, enter:
sqlservr.exe -c -
But some KB Technet articles say do start/stop SQL instance only from cluster administrator
So how to do it
Thanks... more >>
MSDTC stopped working on primary node
Posted by suprfly52 NO[at]SPAM yahoo.com at 5/6/2004 8:07:23 AM
Looking for some advice on an issued that just popped up. Not sure if
this was the cause but after applying MS04-011 and 012 MSDTC will not
run on the primary Node. Main application error message is:
"MS DTC was unable to start because the installation of was not
configured to run on a cluste... more >>
Recognize Server In Cluster
Posted by david_segal NO[at]SPAM hotmail.com at 5/6/2004 6:58:23 AM
Hi All,
I'm posting it here since it seems that the way we access an SQL
server in Culster could be very similar.
I'm trying for quite a few days, without any success, to find out how
to obtain basic info from a Clustered Exchange 2000, such as Mailboxes
list, Storage Groups..., etc.
How sha... more >>
Cluster and User Defined Functions
Posted by Rob Heyman at 5/5/2004 11:15:00 PM
Has anyone had difficulty with UDF's in a clustered environment? We have
some DTS code that references a user defined function. When we run the DTS
package on non-clustered servers, the DTS package executes in several
minutes. However, when we run the same code against the database in a
clus... more >>
Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
Posted by Bill at 5/5/2004 9:34:20 AM
Hi,
I got this error occasionally. I am using two nodes SQL
Server 2000EE cluster running on Win server 2003, it's an
Active/Passive configuration, and they pull data from a
public external RAID. I have applied all latest SPs and
installed MSDTC properly. SQL is still working fine. It
s... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error: 17883 - The scheduler 0 appears to be hung...
Posted by franco at 5/5/2004 6:36:52 AM
Environment:
Clustered SQL Server 2K sp3a (single instance)
Product version: 8.00.760
Problem:
I end up in error 17883.
I am aware that the solution is to apply this patch:
821277 MS03-031:Security Patch for SQL Server 2000 Service
Pack 3.
I am also aware that after you install this cumulat... more >>
Step Guide Setting up SQL 2000 with W2K3
Posted by Kok-Mun, Ho at 5/4/2004 11:11:01 PM
Hi all
I'm looking for step guide to set up SQL 2000 with W2K3. I could only find SQL2000 with Windows 2000
Thanks
Cheers
Kok-Mun, Ho... more >>
ACTIVE/ACTIVE configuration
Posted by Jeff at 5/4/2004 9:25:40 AM
We are looking at installing a 2 Node ACTIVE/ACTIVE SQL
Server configuration utilizing two DELL PE6600 servers,
both connected via FIBRE to a DELL CX200(CLARION). The
OS will be clustered in a ACTIVE/ACTIVE configuration as
well.
The main purpose for attempting this is more for
spreadi... more >>
Win2003 and MSDTC
Posted by Travis Butynski at 5/3/2004 11:02:06 PM
I've read the post/replies explaining how to setup MSDTC on a Windows 2003
server which is definitely great information. At this point, I still have
on problem. The KB article says that Microsoft doesn't recommend that you
create the MSDTC resource in the default Cluster Group or in the group(s... more >>
Win2k sp4 and post sp4 updates
Posted by Joe48184 at 5/3/2004 10:36:02 AM
Hello
I need to update a clustered win2k os. The service pack applied on this clustered server was sp3 a
server build time. I've applied the SLQ sp3 and security roll up with no problems. However, I'm a bit nervou
and not sure the order in wich to apply the windows updates. Do I apply the updates... more >>
Application Databases storing location
Posted by Anonymous at 5/2/2004 11:57:50 PM
We have SQL Database in Cluster volume F:
Cluster volume is mounted in the primary server A1.
We have production and test databases of the applications
stored in the Cluster Storage F:.
Is it possible to store all the test databases of the
applications in the C:(local harddisk) of the primary... more >>
|