| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 NAS or direct attached storage Posted by Ken Shaw at 4/14/2004 6:13:04 PM Am I right in saying that you can't implement a failover SQL Server 2000
cluster using NAS? Ie - you have to be using direct attached storage (like
a big SCSI array) correct?
Cheers,
Ken
...more >>
active/passive cluster upg Posted by geerhead at 4/14/2004 10:20:40 AM I have:
-nt 4 enterprise w/ sp6a
-MSCS Active/Passive
-sql 7.x enterprise w/ sp3
I want to upg the SQL 7 to SQL 2000.
Do I:
-Upgrade server 1 to sql 2000, then move the group to
server 2 and upg it?
thank you...more >>
'Virtual Server' option not available when installing SQL2000 on Win2003 Posted by cterrell NO[at]SPAM earthling.net at 4/14/2004 7:46:45 AM I have a 2-node cluster working properly and have setup a pipe name
alias for the virtual server instance (as per KB article Q815431).
When I start the install of SQL 2000, the second screen that allows
you to choose Local, Remote or Virtual Server has the Virtual Server
option greyed out. Am I ...more >>
Assertion error Posted by MacManaman at 4/14/2004 1:01:04 AM Can anyone provide help regarding recbase.cpp , record.inl assertion error
New cluster system, W2K3 Datacenter, SQL2000+SP3a, IBM x445 Two-way SMP (16CPU,64GB), EMC Symmetrix DMX800
Two instances of SQL Server...
Keep getting assertion error on named instance wich uses MSDTC(msdtc working correct...more >>
Cannot Connect using IP to Clustered Named Instance Posted by MCDBA Wannabe at 4/13/2004 3:34:54 PM I am having trouble connecting when using the IP address to a named
instanced using dynamic port assignments and hosted on a 2K3 cluster (even
when at the console on the node hosting the SQL instance). I receive "SQL
Server does not exist or access denied". There are no entries created in
the ...more >>
clustering error Posted by Man at 4/13/2004 12:57:23 PM i got active\active clustering environment
when i went to clustering administrator i see in cluster
groups the 2 nodes are having red x mark what does it
mean as all the resources[disk] in two nodes are online
while one resource[mssq] in each node is failed in
1node and partially f...more >>
Distributed databases in a cluster Posted by AA at 4/13/2004 12:20:14 PM Hello gurus!
I know that SQL 2000 and very probably Yukon SQL do not support a shared
disk cluster.
So, in the shared nothing schema is possible to (in a Active/Active):
having one SQL 2000 instance running in the Active1 Server with on Database
(like pubs) and in the Active2 Server another...more >>
SQL Server Multiple-Instance Cluster Posted by Earl Spooner at 4/13/2004 10:12:40 AM I am planning on a two node cluster with multiple
instances. I will have two databases and two separate
applications will be going against them. I want 'APP 1'
to go against 'DB 1' on 'NODE 1' and failover to 'NODE
2'. I want 'APP 2' to go against 'DB 2' on 'NODE 2' and
failover to 'NOD...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
clustering Posted by Man at 4/13/2004 6:41:50 AM in clustering groups i got two nodes node 1 is howing
failed and node2 is showing partially online what does it
mean but resources shows online...more >>
sql server license for active passive mode Posted by Raj at 4/13/2004 6:39:28 AM Hi,
if I have a cluster of servers ( 2 to be exact), do I need
one copy of sql server or one for each server ?
Thanks...more >>
(Cluster) Memory settings Posted by AA at 4/12/2004 4:36:43 PM Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have dif...more >>
(Cluster) Memory settings Posted by AA at 4/12/2004 4:36:27 PM Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machines has two processors and 4 GB o Physical Memory (RAM), but I
want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have dif...more >>
Memory setting on a Cluster Posted by AA at 4/12/2004 4:29:16 PM Hello, I am purchasing a HP DL-380 (Cluster)
I am planing to install Windows 2003 and SQL 2000
Both machine has 4 GB o Physical Memory (RAM), but I want to put 6 GB in the
Active Machine and 2 GB in the Passive Machine.
So, That is possible?
1) Is possible to have differentes memory confi...more >>
issues w/SQL clustering in NT4 domain Posted by igor_gonik NO[at]SPAM dell.com at 4/12/2004 9:26:03 AM does anybody aware of any issues when installing SQL2K in NT4 domain? Help is greatly appreciated. ...more >>
Patching SQL in a Clustered Environment Posted by anonymous NO[at]SPAM discussions.microsoft.com at 4/12/2004 8:44:54 AM We are running a SQL within an Active Active Windows
Cluster setup. Will I run into any issues when attempting
to patch SQL with SQL SP3? Are there any issues I should
be aware of when patching the SQL cluster or any
prerequisite patches that need to be applied before
patching SQL in a cl...more >>
Eventlog replication queue is full Posted by Dan at 4/12/2004 7:53:24 AM
I keep receiving the warning message in the event viewer
that the Eventlog replication queue is full.
Error:
EventLog replication queue OUTQ is full. 3 event(s) is
(are) discarded of (total) size 2612.
What should I do to resolve this error?
Thank You,
Dan...more >>
So exactly what IS clustering? Posted by Rob Oldfield at 4/11/2004 9:05:47 PM Hi all,
Some very basic questions here. I have a VB.Net app that is using an SQL 2K
server as it's data source. Everything is working fine but it's a little
slower than I would like. So I've just run the index tuning wizard over the
SQL instance that I'm using.
The result of that is a li...more >>
Cause SQL Server Restricted Mode (db_owner, dbcreator,) Posted by Dan at 4/11/2004 6:52:51 AM
What would cause SQL Server 2000 Enterprise Edition
databases to be in access restricted mode where only
db_owner, dbcreator, and sysadmin?
SQL Server was not placed in access restricted my any
administrator.
This is an active/active cluster with SQL Server 2000
SP3A with Windows 2...more >>
Rename SQL Default instance in cluster Posted by Frank at 4/10/2004 10:07:20 AM HI GROUP
I have my production sql server computer name "sql2k"
and of course the default sql instant name as "sql2k"
because they're running on same box aand stand alone
server.
I do have another active\active sql cluster in place
node1 name is sql1 node 2 name sql2 and virtual computer
nam...more >>
BEST RECOMMENDATION FOR A TESTING SCENARIO Posted by White Jul at 4/9/2004 2:56:30 AM guys:
I would like to have your best advise.
We am planning to install Passive/Active SQL server Clustering in the
production environment that includes two identical Dell PowerEdge 6650 dual
processor servers with a External Disk Storage PoweVault 220S. We have
bought two copies of Windows 2...more >>
SQL Server unavailable during failover Posted by John Oberkehr at 4/8/2004 10:48:04 AM I've noticed with testing my SQL Server cluster failover,
that SQL Server is unavailable during the fail over.
I noticed that when the SQL Server serice is starting on
the fail over node, No one can connect until the service
is started on the backup node.
Is there any way to aviod this w...more >>
sql cluster Error! Posted by tuand2001 NO[at]SPAM yahoo.com at 4/8/2004 9:50:42 AM Hi All,
I'm on the middle of the sql2000 cluster build. Window2000
cluster went though sucessfullly. Went thought most the
steps of the sql cluster and got to the point where it
starts to install sql and it failed with the message: Can
not install sql services.
Thanks for you help in adv...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |