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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|