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

Filter by week: 1 2 3 4

Renaming Cluster Nodes
Posted by RichardT at 2/21/2007 9:28:08 PM
Realise it is a common question and have searched through the group: I have a Windows 2003 R2 cluster (with SQL 2000 SP4) which needs to be renamed (Nodes, cluster name) Is there any way to bypass re-installing SQL 2000 after this has been completed? (Various non microsoft sites point tow...more >>


x64 Cluster experience
Posted by SQLDBA at 2/21/2007 8:11:08 PM
Hello, I'm interested to hear from anyone about their experiences with 64-bit clustering with Windows Server 2003 and SQL Server 2005 - both good or bad. This is before I move with this new platform. Currently doing it with 32bit. cheers. ...more >>

Install New Instance/ Store Data & Log Files in existing drive
Posted by Caroline at 2/21/2007 9:53:36 AM
Hello, I need to install a new instance of SQL Server 2000 on a cluster. Currently, we have three instances. Each instances stores program files on the E:\ Drive. Each instance has its own drive for data and another for logs. However, there is no more unallocated space on the array to ...more >>

SQL 2005 Instances on a cluster
Posted by Neil Paddock at 2/21/2007 7:02:51 AM
We are implimenting a 2005 2 node failover cluster to migrate our existing 10 SQL 2000 databases. Will the server be able to handle 10 instances of SQL 2005? Is there anything else I should be considering while migrating these databases? Thanks for your help, Neil....more >>

adding second node to sql cluster
Posted by Joe McHae at 2/20/2007 8:58:42 AM
I created a one node Cluster in Windows 2003 enterprise server. I then loaded a SQL 2000 Vitrual server. I now need to add a second node. The cluster sees the new node. However when I attempt to load the SLQ executables on the second node the only option I have once I choose the virtual serv...more >>

Cluster / SQL 2005 / SAN storage
Posted by yvette.ye NO[at]SPAM gmail.com at 2/19/2007 6:48:35 PM
Hi...I got some basic questions in regards to setup a lab environment with two nodes cluster over Windows ent 2003, ent SQL 2005 and SAN storage. 1) Would the following hardware be enough: SAN storage, fiber channel switch, two intel servers, 4 HBA (2 for each servers) ? 2) what is the differen...more >>

Renaming a SQL 2000 Cluster
Posted by Amila chandrasekera at 2/19/2007 9:09:24 AM
I need to migrate our SQL 2000 cluster to a new set of hardware and name the new cluster with the same name as the existing one so that none of the applications are affected. How do I change name of a SQL Cluster ? Amila ...more >>

TEMPDB
Posted by Cathy Soloway at 2/19/2007 7:56:05 AM
I know in SQL Server 2005, the recommendation is to break the datafile up into equal part--1 for each CPU because TEMPDB is used so much more. My question is under what circumstances should I do that in SQL Server 2000 64-bit. I have a problematic instance where a lot of sorts and some sto...more >>



SQL Server 2005 Multiple Instance or Virtualization on MSCS
Posted by Andrew Hayes at 2/18/2007 9:20:13 PM
Currently, I have 3 production database servers, each one with it's own backup server for mirroring the databases. So that's 6 servers for 3 default instances of SQL Server 2005. I now need to turn each of them into a cluster for automatic failover, and quite frankly, I think having 3 clust...more >>

Veritas Cluster?
Posted by Neil W. at 2/16/2007 1:33:40 PM
Has anyone used SQL 2000 on a Veritas Cluster? Is setting up exactly the same as on a "regular" cluster? Thanks. ...more >>

Book on clustering
Posted by Himanshu at 2/16/2007 12:28:18 PM
Can someone recommend a good book that covers SQL clustering? And maybe even SQL Mirroring? I'm going to install my first SQL Cluster and I want to be as prepared as possible. All your help is much appreciated. Thanks....more >>

Log Shipping on Clustered SQL Server
Posted by Vick Shaw at 2/16/2007 10:06:02 AM
Hi, I'm trying to implement Log Shipping on a 2 Node SQL Cluster for certain DB's. As far as I understand, I've to share the folder where the transaction logs are backed. My questions are: a) I cannot configure the DB to back the TRN's on a network drive, it says "Not Allowed" The drive s...more >>

After allocating a fixed port in a multi-istance cluster SQL Server 2005, istances don't do on-line
Posted by SP at 2/15/2007 6:35:30 PM
After allocating a fixed port in a multi-istance cluster and SQL Server = 2005, istances don't do on-line. Help! SP...more >>

Problems with mounted drives
Posted by SP at 2/15/2007 5:16:56 PM
I have a two nodes Windows Server 2003 Ent Edition Sp1\SQL Server 2005 Ent Edition cluster. I use RAID5 drives for data and RAID10 drives for TLog. I use: - letter to access data drives (es. K:, M:, ecc...) - mounted drive to access log drives (es. K:\SQL2005_LOG ---> first RAID10 drive...more >>

Migrating SQL 2000 Clustered Server
Posted by EF NO[at]SPAM nospam.nospam at 2/15/2007 12:00:00 AM
Hi All, We need to replace our SQL 2000 servers and SAN with new servers and SAN. I hope that someone can give me some advices on what is the best way to do it. We hope not to make any changes on applications using this SQL server. Current Setup 2 nodes SQL 2000 Cluster Server Windows 2...more >>


DevelopmentNow Blog