all groups > sql server clustering > february 2004 > threads for february 1 - 7, 2004
Filter by week: 1 2 3 4
Suspect Database
Posted by Troy Laughlin at 2/6/2004 11:36:05 PM
I have a database on the passive node that frequently gets marked "suspect." I'm looking for any insight as to why this might happen, as well as how to best handle the suspect database - restore, replicate, etc
Any information is greatly appreciated
Thanks
Troy Laughlin... more >>
SQL Cluster
Posted by Balaji at 2/6/2004 1:24:00 AM
Whenever Internet link is down, the user cannot connect to
SQL server 2000. The SQL Server 2000 is installed on
Win23K Cluster server.
When checked the event log,
Error ID = 17052 - [sqsrvres] Online Threat QP is not
online error occurs.
Error ID = 17052 - ODBC SQLdriver Connect Failed... more >>
MSDTC on W2K3
Posted by Stephen Strong at 2/5/2004 5:01:05 PM
Does anyone know how much disk space MSDTC requires when adding to a cluster group? Does it depend on the size of the enlisted transactions??... more >>
Cluster nodes with different hardware spec
Posted by Bret at 2/5/2004 3:57:55 PM
Is there any issue with building a cluster with 2 nodes
(Active-passive)and with different hardware spec (but
same mem size, different number of processors and speed)?
It is temp situation until we found another hardware with
same spec as the first one. Thanks in advance... more >>
Resizing volumes
Posted by Stephen Strong at 2/5/2004 2:21:07 PM
Expanding virtual disks presented to a MCS cluster on W2K from a SAN works well - simply increase the virtual disk on the SAN then use diskpart (not version 1.0!) and SQL continues without a problem. Decreasing the size of a volume is not so easy. Has anyone else done this without backing up the d... more >>
Good cluster gone bad
Posted by Jim Rackley at 2/3/2004 12:48:26 PM
First, thanks in advance for any help you can provide!
SITUATION:
Two Win 2003 Enterprise Servers, fully updated
Active/Passive SQL Server 2000 Cluster
Shared RAID device
System has been running without error for 4 months
PROBLEM:
I can no longer failover to my passive server nor can I mo... more >>
Physical Disks vs. Partitions
Posted by Michael [multnomah] at 2/2/2004 1:33:47 PM
We have our 2 node SQL Server 2000 [Windows 2003] Cluster
connected to a NAS device. We have created 4 LUNs, 2 for
each node, with one DATA and one LOG. On the second node
[QAT2] we have the 2 LUNS carved up into 6 partitions [3
for DATA and 3 for LOG, K:, L:, M:, N:, O:, P:]. On the
se... more >>
8-16 instances on a SQL2K cluster advisable?
Posted by Rinus Heer at 2/2/2004 6:48:10 AM
Hello,
I would like to know your opinion about running 4-8 SQL 2K
instances on each node of a multi-node (2) cluster, with 8
production databases on each node (spread over the
instances).
Hardware: 2 Pentium 4 2.8 GHz dual processor systems with
2 Gb memory (can be upgraded with processor ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Install SQL 2000 Cluster on Windows 2003
Posted by sql at 2/1/2004 11:04:00 PM
Would like step by step instructions for setting up windows 2003 and SQL
2000 clustering services. I also need instructions on installing the OS as
well which is windows 2003
Thanks
... more >>
Data
Posted by Viraj at 2/1/2004 5:53:13 PM
I am in the planning process of upgrading the hardware on
our cluster. I need info/advice/suggestions on how to go
about this.
I am running an active/active cluster on 2 ML370 servers.
They are running Windows 2000 Advanced Server/SP2, MSSQL
2000 Enterprise/SP2.
I want to know if all I hav... more >>
CPU usage changed after upgrading to MS SQL Server 2000 from MS SQL Server 6.5
Posted by kct NO[at]SPAM emia.com.au at 2/1/2004 3:55:57 PM
Hi All,
I had two Window NT 4.0 Server, say A and B... We recently upgraded
from MS SQL Server 6.5 to MS SQL Server 2000 on Computer A, and for
Computer B, I installed SQL Server 2000 from scratch. These two have a
same RAM(512MB) and CPU speed...so the setup for hardware is almost
identical... more >>
Cannot install on Windows 2003 cluster
Posted by Ole at 2/1/2004 6:47:24 AM
I have trouble installing default as well as named
instances og SQL Server 2000 on Windows 2003 cluster. I've
tried on a couple of different systems with the same
result.
The setup fails every time while creating virtual server
resources.
Here's the tail of sqlstp.log:
15:13:22 Begin ... more >>
|