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 > may 2007 > threads for may 15 - 21, 2007

Filter by week: 1 2 3 4 5

SQL Clustering Problem
Posted by Pat Hall at 5/21/2007 10:19:00 AM
I added two new nodes to our existing SQL 2000 server cluster (evicted 1 node 1st). No problems both new servers see the disks in the SAN but don't own them yet, of course. Ran into a problem installing SQL Server 2000 from the active node. I followed the steps in BOL and got to the "Remote...more >>


Windows 2003 cluster trust issue during install?
Posted by scott at 5/18/2007 6:35:02 AM
We had a problem with one of our servers which is apart of a cluster ( NODE1 ). It required reloading and now we're back to installing SQL. When we're on NODE2, its partner, and try to install SQL, it complains about NODE1 (see logfile). However, when we try to load SQL from NODE1 the same ...more >>

Windows 2000 SQL cluster
Posted by Newbie at 5/17/2007 9:03:01 PM
Hi, I am a new guy in Windows 2000 in SQL clustering. The SQL cluster cannot failover while 1 node is down. I would like to know if there is any standard checkup procedure or tools to collect information for further problme analysis. Thanks a lot. ...more >>

Error 42d during Fail Over SQL 2000 Enterprise in a Server 2003 Ent. Cluster
Posted by christophercnewton NO[at]SPAM gmail.com at 5/16/2007 2:20:37 PM
Hi All, I've been struggling with this issue for a few days now. We have 2node Server 2003 Entprise cluster with a fresh install of MSSQL 2000 SP3a. Everything works great until I attempt to simluate a node failure. Node 2 starts every service fine with the exception of the 3 SQL services: ...more >>

Applying SP on SQL Cluster (active/passive) after new nodes Added
Posted by Pat Hall at 5/16/2007 11:44:01 AM
Ran into a problem in scheduling applying the Service Pack to our SQL 2000 active/passive cluster when we add new nodes. 50 plus databases and an unknown number of apps. I'm wondering what people do to ensure that no apps/people are trying to access the databases when the s...more >>

Clustering a standalone SQL server + storage array
Posted by Andoni at 5/16/2007 8:12:01 AM
Hi all, i'm wondering whether any of you clustering experts could help. Our apps team look after a trading system that uses an HP DL360 server running SQL 2000 SP3a with a few small databases on it. This is a critical server as it stores trading system information, market orders etc. A req...more >>

sp_configure (RECONFIGURE)
Posted by Alex at 5/16/2007 12:00:00 AM
Hello When I run (copied from BOL as an example of enabling AWE) the following statement I got an error.It did changes but with error message. Should I use WITH OVERRIDE? Can someone explain on subject? Is it BOL incorrect? sp_configure 'show advanced options',0 RECONFIGURE GO sp_confi...more >>

SQL DB without any stored procedures?!
Posted by Manoj Kumar at 5/15/2007 3:01:02 PM
Hi, Does any one have any experience with the Hibernate layer [which acts as an abstraction layer between DB & application layers]? The factor which is bothering me is the absence of stored procedures. All transactions are done via this Hibernate Layer. What I am looking at is a system whic...more >>



SQL 2005 32 bit to 64 bit Migration
Posted by Keith Madaras at 5/15/2007 11:42:01 AM
Hello, We have a 2 node Active/Passive 32 bit SQL cluster. We wish to convert the cluster to 64 bit Server 2003 and 64 bit SQL 2005. It is of cheif importance that we don't have an exended outage as we are an ASP and our clients don't take well to this type of thing. If anyone can shed...more >>

Moving SQL2005 fail-over cluster between domain
Posted by Pierluigi at 5/15/2007 6:41:01 AM
Hi everybody, I'm looking for documentation about moving a fail-over cluster of SQL2005 between different IP network and between difefrent Windows domain. Some advice ? Thanks in advance. Pierluigi...more >>


DevelopmentNow Blog