Groups | Blog | Home


Archived Months
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
all groups > sql server clustering > february 2005 > threads for february 22 - 28, 2005

Filter by week: 1 2 3 4

Newbie MSDTC question
Posted by Lapchien at 2/28/2005 9:37:59 PM
What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster? Cluster is already setup and virtual sql instance running ok... Thanks ...more >>


memory usage
Posted by Calvin Do at 2/28/2005 4:41:02 PM
Hello, I have a sql 2000 box that has roughly 15 datbases. How do i determine how much memory/cpu a particular db is using? thanks! Calvin ...more >>

Instance wil not come online
Posted by Hans de Bruin at 2/28/2005 4:00:02 PM
2 out of 4 instances on my 3 node cluster wil not come online on one off the clusternodes, unless I add an alias (which I removed after installing sp3). The application eventlog complains about not being able to connect to the instance. I can connect to the instance remotely, but apparently ...more >>

Microsoft OLE DB Provider for SQL Server"
Posted by Yianni at 2/28/2005 1:19:02 PM
I receive a "Cannot generate SSPI context" error message when you try to connect to a SQL Server 2000 SP3 server computer. According microsoft's article ID 843248 there is a hot fix. I do not want to install SP2 just the hot fix. Does anybody know the actual ID name of the hotfix. I am tr...more >>

Two named instances. Why ?
Posted by Rubens Luque Sanches Junior at 2/25/2005 8:24:02 PM
What is the better to use in active/active SQL 2000 cluster ? 1 Default instance and 1 named instance or 2 Named Instances ? There are any advantages or disadvantages ? thanks a lot ! Rubens ...more >>

Having fun with moint points
Posted by Hans de Bruin at 2/25/2005 4:13:41 PM
To keep the number of driveletters to a minimum, have the same directory structure on the instances and do something with disks and performance I tried this: MSSQL$I1\Data \Data1 <- mount point \Tlog \Backup \Backup1 <- mount point MSSQL$I2\Data \D...more >>

Want to Call DTS Package....
Posted by Patrick at 2/25/2005 1:48:22 PM
Hi All I want to call DTS Package from Job. How, can I do that ? First DTS Package transfers data and then it calculates on that imported data. Wating for reply Silent Ocean ...more >>

VBScript to Enumerate Cluster info
Posted by news.cox.net at 2/24/2005 8:06:26 PM
Does anyone know how to enumerate cluster info (Microsoft cluster server 2000) through VBS. But more specifically, is there a way to execute the MOVE GROUP function from within VBS/VBScript. Thanks, JFR ...more >>



MSDTC question
Posted by Calvin Do at 2/24/2005 12:57:14 PM
Hello, may be a dumb question, but how do i determine if i've setup msdtc correctly on a sql 2000 cluster? thank you Calvin ...more >>

EXIT CODE 51- SEtup failed to perform the required operation on t
Posted by Anand Musunur at 2/24/2005 12:49:03 AM
I am trying to install a named instance on an active/passive cluster using sql 2000 and windows 2003 both entrprised editions. HEre is the latest sqlstp.log which says it failed/. 01:45:22 Begin Setup 01:45:22 8.00.194 01:45:22 Mode = Normal 01:45:22 ModeType = NORMAL 01:45:22 GetDefinition...more >>

Change from Active\Active to Active\Passive Cluster
Posted by Joe K. at 2/23/2005 6:47:05 AM
I have a SQL Server 2000 Cluster with Windows 2000 Server. The Cluster was set up as a Active\Active and I would like to change it to Active\Passive. What do I need to change go from Active\Active to Active\Passive? Thanks,...more >>

Maximize memory usage on active-active sql cluster
Posted by ettore.pancini NO[at]SPAM gmail.com at 2/23/2005 2:02:25 AM
we have an active-active sql cluster configured as follow: server A - 4gb ram - sql server instance #1 server B - 4gb ram - sql server instance #2 currently each sql instance is configured to use at most 2gb of ram. in case of failover, both instances switch on one server, effectively usinge ...more >>

SQL Cluster in Windows 2003
Posted by j05e at 2/23/2005 1:21:02 AM
Hello: I have installed SQL 2000 Enterprise in a Microsoft Cluster Windows 2000 several times. I am trying now to install it on a MSCS Windows 2003 and I can see there are several differences. First of all, when I did with Windows 2000 the first step was to configure the Microsoft Distribu...more >>

SQL Clustering Options
Posted by TABMCSE at 2/22/2005 7:03:02 PM
I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you....more >>

Using SQL Mail in a cluster
Posted by Calvin Do at 2/22/2005 3:46:41 PM
Hello, I'm trying to set up alerts for jobs and backups, using sql mail. Will this work in a clustered enviroment? if so, can you please forward some information on how to get this set up? thanks in advace. Calvin ...more >>

CLUSTER NAME
Posted by Aju at 2/22/2005 1:03:43 PM
Hi , is there any command to display current cluster name through query . Thanks ARR ...more >>

Passwords for cluster and servers
Posted by Dave at 2/22/2005 6:58:29 AM
I have a 2 node cluster running Win2000 enterprise and MS clustering. Also SQL server. Would there be a problem using the same domain password for SQL and for the clustering service? I thought I read that there may be a problem but I don't recall where it read it. Thanks for any help. ...more >>


DevelopmentNow Blog