I am getting ready to install a new cluster and was wondering what the best cumulative update would be. I am installing it on a HP 460c blade server...

=?Utf-8?B?RGF2ZSBC?=

07-30-2007 08:17 AM
Geoff N. Hiten

We would like to upgrade our SQL 2000 clusters to multi-node using Windows Server 2003 (currently a Win2k3 2 node cluster). Does SQL 2000 support up...

=?Utf-8?B?RkNCIERTUw==?=

07-29-2007 08:56 PM
=?Utf-8?B?TGluY2hpIFNoZWE=?=

Hello there For my knowlage to implement sql server failover clustering i need at least 2 servers: one as primary node. and second as secondery...

Roy Goldhammer

07-29-2007 08:54 PM
=?Utf-8?B?TGluY2hpIFNoZWE=?=

Hi, We have a 2 node, active-active, 2 instance, 64 bit SQL 2005 Enterprise Cluster. When you open the SQL Configuration Manager on either server,...

=?Utf-8?B?U3RldmVU?=

07-27-2007 10:37 AM
Geoff N. Hiten

This is a two node cluster running 64-bit wk3 os and sql 2k5 64-bit. Everything works ok except SQL cannot "see" the drives. There are log...

=?Utf-8?B?U1FMR3VydV9ub3Q=?=

07-27-2007 09:24 AM
=?Utf-8?B?U1FMR3VydV9ub3Q=?=

Hello there If i set server as failover clustering can i use simple recovery model?

Roy Goldhammer

07-26-2007 11:44 AM
Geoff N. Hiten

Good day to all of you SQL/Cluster GURU's I recently asked a question reagrding a Windows 2003 Enterprise/SQL 2005 Standard 2 node cluster I have, I...

=?Utf-8?B?U2NvdHQgQ3VtbWlucw==?=

07-25-2007 10:56 AM
=?Utf-8?B?U2NvdHQgQ3VtbWlucw==?=

I have been trying with no success to start my SQL Server in single user mode and login. Here's the scenario: I've got a one node cluster with SQL...

=?Utf-8?B?QS4gUm9iaW5zb24=?=

07-25-2007 09:07 AM
Geoff N. Hiten

Apologies for the long post. I wanted to try to get all the information in the initial post. The basic premise is to replace the server hardware on...

a.russell.morris@gmail.com

07-25-2007 08:03 AM
a.russell.morris@gmail.com

Hi all, As an SQL DB Administrator, do you have any checklist which can be done in daily/weekly/monthly basis for operational continuity. Such as,...

Koray Ersin

07-25-2007 03:22 AM
Koray Ersin

Hi All, We are currently working on setting up a 2-Node cluster using SQL Server 2005. Hardware : HP Blade servers : BL 460c (c7000 enclosure) SAN...

=?Utf-8?B?U0o=?=

07-23-2007 01:32 PM
Geoff N. Hiten

Hi, We have 2 2-node SQL clusters. We patch & update these servers monthly and there's different techniques my colleagues use when we patch the...

Mike Bonvie

07-23-2007 12:02 PM
Mike Bonvie

Hello there can one server be passive server of two diffrent failover clustereds?

Roy Goldhammer

07-23-2007 08:02 AM
Geoff N. Hiten

Hi, I am trying to expanding MSDB under SSIS and getting following error: TITLE: Microsoft SQL Server Management...

=?Utf-8?B?WXVob25n?=

07-22-2007 11:52 PM
jessy vinod

We have xSeries 460(x3950-8878) IBM Machine , mounted at win2003 and sql 2005 64-bits. At future processes, this machine will take over all...

Krisnamourt via SQLMonster.com

07-20-2007 02:11 PM
Krisnamourt via SQLMonster.com

I have a big client that made the following big mistake: They had a two node Active/Active cluster. They evicted node B. A little later, since they...

=?Utf-8?B?Q2FtaWxv?=

07-20-2007 02:10 PM
Tom Moreau

Does anyone have or know wher I can find a go-live database checklist for SQL Server 2005 cluster? Covering security, performance,...

=?Utf-8?B?ZGVuaXNl?=

07-20-2007 11:32 AM
=?Utf-8?B?ZGVuaXNl?=

We are planning the following setup as part of our Business Continuity Planning. We have an active passive cluster in the production and we will also...

=?Utf-8?B?QWJoaQ==?=

07-17-2007 02:13 PM
Russ Kaufmann [MVP]

Hi All, I have a couple questions on SQL clustering with reference to DR se tup Assuming that I have a cluster in production and another cluster...

=?Utf-8?B?QWJoaQ==?=

07-17-2007 11:18 AM
=?Utf-8?B?QWJoaQ==?=

Hello, We are seeing a very bizarre occurence in the config mgr. I have a win2k3/sql2k5 2-node, single instance cluster. When we look in the...

Christopher

07-17-2007 03:15 AM
Toni

two nodes, active/active cluster, SQL 2000 built on Windows 2003. Why so many dbs show offline and how to bring them back???? Thanks so much for...

=?Utf-8?B?WnJpY2g=?=

07-16-2007 04:55 PM
Tom Moreau

I get the nasty "Connection to target machine could not be made in a timely fasion" error when trying to start SSCM on the second node even if the...

mEmENT0m0RI

07-16-2007 10:20 AM
mEmENT0m0RI

I get the nasty "Connection to target machine could not be made in a timely fasion" error when trying to start SSCM on the second node even if the...

mEmENT0m0RI

07-16-2007 10:14 AM
mEmENT0m0RI

If we have our databases tied to a SAN, why would I consider SAN based replication vs database mirrroring as a Disaster Recovery solution? Database...

Hassan

07-16-2007 09:46 AM
mEmENT0m0RI

Hi all, Please help.We are installing SQL2000 Ent in a 2 node W2K3 cluster and it gets pass "Setup has enough information ... and start copying...

=?Utf-8?B?VG9ueUNhZGVsaW5h?=

07-15-2007 08:26 PM
=?Utf-8?B?VG9ueUNhZGVsaW5h?=

Let me know what you think of the product.Is it worth considering than say the MSFT cluster ? Thanks

Hassan

07-14-2007 12:45 PM
Rodney R. Fournier [MVP]

Problem with response time depending on which node of an active/passive cluster is active. If checked everything I can think of or Google...

=?Utf-8?B?UGF0IEhhbGw=?=

07-14-2007 12:30 PM
Anthony Thomas

Anyone using SAN based replication care to share a rough pricing estimate for the solution ?

Hassan

07-14-2007 01:06 AM
=?Utf-8?B?TGluY2hpIFNoZWE=?=

Good day SQL /Cluster GURU's My question is a general one. I currently have a basic two node SQL cluster one active/one passive running Sql 2005...

=?Utf-8?B?U2NvdHQgQ3VtbWlucw==?=

07-13-2007 11:02 AM
=?Utf-8?B?U2NvdHQgQ3VtbWlucw==?=

Has anyone had any experience clustering Analysis Services in its own Resource group? Our system folks here were able to place SSIS in a different...

Mark

07-13-2007 07:48 AM
Mark

I have two node SQL 2005 Cluster on Windows 2003 SP1. Now, I have to change both IP address and subnet Windows Cluster servers. is it possible? or...

=?Utf-8?B?VFVGQU4gT0RVTkNV?=

07-11-2007 10:58 AM
Russ Kaufmann [MVP]

As you set up disaster recovery(DR)of your existing production data say in DataCenter 1 to your DR site that may on the other side of the...

Hassan

07-09-2007 10:56 AM
TheSQLGuru

Does it get away from the shared disk limitation we have today that is considered a single point of failure ?

Hassan

07-09-2007 09:29 AM
Rodney R. Fournier [MVP]

Hello All Guru's, Does anyone have experience building a Windows 2003 Cluster running two instances of SQL Server 2005 in an ACTIVE/ACTIVE scenario...

=?Utf-8?B?RnJlZEc=?=

07-06-2007 02:46 PM
=?Utf-8?B?bXJkZW5ueQ==?=

Hi, we have a 2 node cluster running Server 2003 with a single instance of SQL 2005. We are looking to migrate as many apps as possible to SQL...

TJ

07-06-2007 02:38 PM
=?Utf-8?B?bXJkZW5ueQ==?=

When I install SQL 2005 failover setup, it show the error message " There was an unexpected failure during the setup wizard. You may review the setup...

=?Utf-8?B?U3RldmVu?=

07-05-2007 03:38 PM
=?Utf-8?B?c2F2YWdsaWFubw==?=

Guys, Can anybody describe me the procedure of restoring master database on a 2005 cluster? I stopped all the services that may logon into the...

mEmENT0m0RI

07-03-2007 11:46 PM
Uri Dimant

Database mirroring works either way depending on which mode you're in. It's the automatic failover in high safety mode that may or may not meet...

Joe Yong

07-03-2007 04:46 PM
Joe Yong

Greetings all...Thanks in advance... I am so NEW to clustering, I really don't know if I'm asking right question(s) or not...I have been reading...

=?Utf-8?B?SmltaVRoZUpldA==?=

07-02-2007 02:04 PM
Geoff N. Hiten

I have taken SQL Server resources OFFLINE. Will the SQL Server resources be brought ONLINE automatically during failover or will it be in the...

=?Utf-8?B?U2FtdWVs?=

06-30-2007 02:03 PM
Geoff N. Hiten

After installing SQL Server 2005 Cluster (64 bit) on a Windows 2003 EE server, I received the following error listed below when I tried to connect to...

=?Utf-8?B?Sm9lIEsu?=

06-30-2007 05:50 AM
Tom Moreau

Hi, I got this error when I move the log file to a diff location in the cluster environment. Any ideas and solution? Thanks Msg 5184, Level 16,...

mecn

06-29-2007 10:19 AM
mecn

Ok my job is done. I have built a fully tested Windows and SQL active/passive cluster. Not the software guys take over but as an inquiring IT guy I...

=?Utf-8?B?RU1hZ2lkc29u?=

06-29-2007 08:58 AM
Geoff N. Hiten

A quick rant - After days of study, hours of install, and some killer directions for Brad M McGehee I began to install a SQL Cluster on a...

=?Utf-8?B?RU1hZ2lkc29u?=

06-29-2007 08:21 AM
Geoff N. Hiten

I have posted this once before but I cannot find the thread for some reason. I have a client that I am going to be doing some colo hosting for. He...

=?Utf-8?B?TWFydHkgU2hpZmZsZXR0?=

06-28-2007 02:44 PM
=?Utf-8?B?TWFydHkgU2hpZmZsZXR0?=

We are currently running SQL Server 2000 Enterprise edition in a two-node active-active cluster. We are looking to upgrade to SQL Server 2005, but...

=?Utf-8?B?RHlsYW4gUGV0ZXJz?=

06-28-2007 09:22 AM
Rodney R. Fournier [MVP]

We have a 2003 clster with 2005 sql running across 2 nodes. We ran SP2 on the active node, all went through successfully, but it dodnt. It left one...

johnboy1973

06-27-2007 02:28 PM
jonahvoolf@gmail.com

I understand that Microsoft do not support SQL Server 2005 failover clusters where the cluster instances are also domain controllers. Can anyone tell...

Andy Johnson

06-27-2007 10:16 AM
Rodney R. Fournier [MVP]

Greetings, I've inherited a cluster configuration and I'm new to administration of clusters. 2 node 64 bit SQL running on 64 bit Windows 2003...

Sammi

06-25-2007 10:40 PM
=?Utf-8?B?TGluY2hpIFNoZWE=?=

I need to create a design document for or new SQL Cluster. I know what I need to do bud don't know how to get it in a proper document. Has anyone an...

=?Utf-8?B?WmVrc2tl?=

06-25-2007 08:29 AM
=?Utf-8?B?WmVrc2tl?=