all groups > sql server clustering > february 2007 > threads for february 1 - 7, 2007
Filter by week: 1 2 3 4
Multiple SQL Clusters on one EMC LUN?
Posted by Andrew Williams at 2/7/2007 6:19:33 PM
Hello,
We have a Production SQL 2000 Cluster and are now developing on SQL 2K5 as
we plan to migrate shortly. We'll be introducing new hardware into
production with 2K5 installed. We would like to use a 'straddle migration'
method by utilizing both 2K and 2K5 in production at the same tim... more >>
AntiVirus Software for SQL Cluster Servers
Posted by Yuhong at 2/7/2007 7:54:01 AM
Hi, I am setting up a 2 nodes sql cluster and not sure what AntiVirus
software I should use. Any information will be greatly appreciated.
... more >>
MSDTC / sql2000 active/active
Posted by burt_king at 2/7/2007 7:13:02 AM
We need to create an active/active sql 2000 cluster on 2003 enterprise
server. Do I need multiple MSDTC or just one?... more >>
Issues creating a new failover cluster on the same server
Posted by Dan at 2/6/2007 9:17:01 AM
We have a sans and a server box that currently has a SQL 2005 Failover
cluster installed, we are attempting to install a new SQL 2005 Failover
cluster but ran into an issue. After setting up the new cluster group and
installing the instance to this group the installer modified the SQL browser ... more >>
3624 Errors
Posted by Cathy Soloway at 2/6/2007 5:34:01 AM
I have a 2-node cluster (32-bit) at 8.00.818 that has approximately 100
databases of varying sizes that are used to feed some tax websites. Recently
we did a repair on one of the databases with a DBCC CHECKDB with
ALLOW_DATA_LOSS to repair some issues with one database. That went well.
La... more >>
Add a 3rd node to a 2 instance active/active cluster
Posted by Hassan at 2/4/2007 9:24:54 AM
If I add a 3rd node to an already existing 2 node active/active cluster, do
I have to take the other 2 instances offline as I configure the 3rd node?
I have never configured a cluster before, but I am under the assumption that
when you build a cluster, each nodes should be able to map to the ... more >>
Does SSRS support cluster?
Posted by Ken at 2/3/2007 9:50:01 AM
SQL Server 2005 Reporting Services, Notification Services, and Integration
Services are not cluster-aware; they are always installed as stand-alone
components, but can use a clustered SQL Server database.
Words above come from sql 2005 help on msdn, but the guide of technet for ms
Reporting... more >>
Why multi-instace cluster and not active-active ?
Posted by Hassan at 2/2/2007 9:10:51 PM
Why is it called multi-instance cluster and not active-active ? I thought I
heard the explanation before but cannot seem to recollect.
Thanks
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error trying to start new maintance plan
Posted by Wayne at 2/2/2007 1:31:56 PM
I have a SQL2K5 cluster and I have what I believe is a valid setup but I am
now getting the following error/warning when I try to start the maintenance
wizard or start a new maintenance plan. I have installed workstation tools
on both.
I have Windows 2003 64bit SQL2K5 SP1 with all current pat... more >>
SQL Cluster cleanup
Posted by Alex at 2/2/2007 10:46:38 AM
Hi,
I had the task of renaming virtual SQL name on an exiting 3 node Windows
2003 SP1/ SQL 2000 SP4 cluster from SRV1\INST1 to SRV1\INST2. The first
thing came up to my mind was to change SQL Cluster name resource to the new
one. After the change, SQL Service resource generated a lot of ODB... more >>
third node will not join cluster
Posted by wpb999 NO[at]SPAM yahoo.com at 2/2/2007 6:02:37 AM
We did this before so we know the process works. The background info
is we have a massive active/active
(2 node) sql cluster running Datacenter 2000. We need to upgrade
hardware and OS. migrating DB's is not an option due to huge numbers.
We created two new servers with Datacenter 2003_R2. Adde... more >>
Side-by-side upgrade - moving master, msdb and model
Posted by Johnny Lundgren at 2/2/2007 12:58:01 AM
Hello,
I am soon performing a side-by-side upgrade on completely new hardware.
The old stand-alone server has a 32-bit SQL 2000 Standard Edition SP3a
installed.
I want to move all databases to a 64-bit SQL 2005 Standard (SP2 - when it is
released) clustered installation on the new hardwar... more >>
Run out of alphabets
Posted by Hassan at 2/1/2007 7:14:03 PM
When you set up say 3 active and 1 passive multi instance cluster and
especially if any one instance uses say 10 alphabets, how do you configure
the cluster then ? Can you use something other than alphabets for your
resources ? This would be tied to a SAN too...
... more >>
Any documentation to set up multi instance cluster
Posted by Hassan at 2/1/2007 7:12:09 PM
I want to set up 3 active and 1 passive on a 4 node cluster and would like
to see an install guide for something like that. Can anyone redirect me to
one ?
Thanks
... more >>
client can't connect when instance on one particular node
Posted by unc27932 NO[at]SPAM yahoo.com at 2/1/2007 3:40:22 PM
OK - so here's the setup - two node cluster (we'll say Node1 & Node2),
two instances (so multi instance, we'll say SQL1 & SQL2). W2K3 server
on the nodes, SQL 2000 SP4 for SQL version. Our situation is this.
We removed Node1 from the virtual server using the setup utility in
SQL 2000 in order ... more >>
..newbie.. cluster multi-istance..
Posted by marco.crespi NO[at]SPAM gmail.com at 2/1/2007 1:30:27 AM
Hi,
I must install M$ SQL2005 standard on two node in cluster enviroment.
I wanna know some best practices to resolve the installation in the
better way.
The server is based on two blade dual processor dual core. I've a SAN
configured with 4 LUN, each with 1 partition (eventually a can
recon... more >>
|