Hi, A server which is configured as SQL 2005 Cluster as an Active/Passive node. I have a query, if I can configure SQL 2005 Cluster as an...

Ankur

08-27-2008 06:10 PM
Linchi Shea

Hello, We are about to migrate from one storage system to another & the biggest stumbling block we have at the moment is how to migrate our SQL 2005...

MattRidd

08-25-2008 10:37 AM
Geoff N. Hiten

I have a SQL 2005 SP2 cluster. I recently applied some patches to the stand by node and noticed an error on reboot. The error in the system log...

Tony

08-25-2008 09:26 AM
Med Bouchenafa

Are you looking for a Job in India??? You have experience in Java, Oracle, .NET, SQL Server, SAP and testing tools. Than you can wait a minute and...

Naveen

08-22-2008 06:13 AM
Sean (UK)

Hi All.. Just looking for some opinions on which path to follow.. We have a requirement to build 2 SQL server 2005 boxes on windows 2003 R2. The...

Ramkumar

08-21-2008 02:31 AM
John Bell

I want to create a clustered sql server instance. There is a standalone instance of sql server on one of the servers I verified it was not clustered...

mj

08-20-2008 07:04 PM
mj

Hi Guys, I have experience in single instance cluster installation, but I don't have multiple instance cluster installation. I check a lot of...

Iter

08-19-2008 01:59 PM
Geoff N. Hiten

Hello, I've been attempting to build my first Windows 2008 failover cluster and wanted to create the MSDTC resource since this will be a SQL cluster...

J. Rich

08-18-2008 01:41 PM
J. Rich

Objective: SQL S setuperver cluster I am trying to assist my cllient who has an MS cluster setup. However it appears they had SQL Server installed...

mj

08-15-2008 12:20 PM
Geoff N. Hiten

Hello, I have a problem during SQL resources failover from node A to node B on my cluster. All works correctly if all resources are active on node A....

Maurizio

08-14-2008 03:42 PM
Linchi Shea

We moved our environment from a stand aloone SQL Server scenario to a clustered environment. Our cluster consists of two nodes, set up...

A. Robinson

08-11-2008 11:08 AM
A. Robinson

I need to update the catalog on my SQL 2000 box so run distributed queries from a 64-bit SQL Server 2005 server to a linked 32-bit SQL Server...

Mike

08-06-2008 10:46 PM
Charles Wang [MSFT]

I just installed SQL Server 2005 SP2 Hotfix 8 on my two node active/passive cluster and now SQL Server Agent won't start. There are three entries in...

ebferro

08-05-2008 02:36 PM
ebferro

I have installed a 2nd instance of sql on an Active passive SQL 2005 cluster and the setup failed with the following: TITLE: Microsoft SQL Server...

Lontae Jones

08-05-2008 03:22 AM
Lontae Jones

I'm attempting to add some T-SQL steps to an SQL Agent job on my SQL Server 2005 installation. The install is on a two node cluster with node 1...

ebferro

08-04-2008 02:12 PM
Antonio Soto

Lost power on the active node of my SQL Server. It failed over to Node 2 without problem, but when I brought it back to Node 1 (the server that...

Paul Essick

07-31-2008 01:14 PM
Jeffrey Williams

When I initiate a failover test on a cluster resource it will go offline and then back online, but to the same node and not to the other node in...

JimRBG

07-24-2008 10:28 AM
John Toner [MVP]

In order to backup the db in a clustered instance, is it possible to use a device mapped locally for each node of the cluster? Has this device to...

Pasquale

07-23-2008 05:43 PM
Geoff N. Hiten

In a two node cluster with two SQL clustered instances, it it possible that the related two resource groups sharign the same storage unit with a...

Pasquale

07-23-2008 03:11 PM
Linchi Shea

I have a two node cluter. Each node has a local drive (named C) and two storage units in a SAN, one for the data and the other one for the log. Is...

Pasquale

07-23-2008 12:42 PM
Denny Cherry

I have installed two SQL Server clustered instances in a two node cluster (a/a). Now, I need to test the environment with a workload in presence of...

Pasquale

07-22-2008 11:11 PM
Linchi Shea

Is it possible to rename the default SQL Server 2005 instance installed in a cluster? I would like to rename the instance name and not the virtual...

Pasquale

07-22-2008 11:08 PM
Linchi Shea

Is it possible to name similarly the virtual server and the SQL instance for a SQL clustered instance)? In other terms, is it a best practice to...

Pasquale

07-22-2008 11:06 PM
Linchi Shea

In a two node cluster (active/active), I have installed two SQL Server 2005 instances in order to use both nodes. The virtual server name of the...

Pasquale

07-22-2008 08:33 PM
Denny Cherry

Hello, I've two systems running Windows 2000 advanced server SP4 and on this two SQLServer 2000 Sp3a instance (one per node) that do not failover...

Ste

07-22-2008 11:05 AM
Ste

Hello, I have a SQL 2005 Active/passive EE cluster. I am trying to install a second instance and it doesnt see my disk probably due to the fact...

Lontae Jones

07-21-2008 08:23 PM
Geoff N. Hiten

I have two servers. On the first server I want to put two dbs and on to the second second server I want to put the third db. The dbs on the first...

Pasquale

07-19-2008 10:51 PM
Geoff N. Hiten

Hi Guys, We are considering whether an SQL cluster (MSCS) may have any advantages from transaction handling point of view. I mean mscs is a solution...

Sabi

07-18-2008 09:22 AM
Russ Kaufmann

Can anyone tell me if DSO can be used to connect through to a 2005 AS cluster instance? TIA

Paul Conroy

07-14-2008 06:19 PM
Paul Conroy

I need to install SQL Server 2000 on a Windows 2000 cluster - Yes I know how sad is that... Anyhow, I have following the installation based on the...

Ross Mistry

07-11-2008 09:06 AM
Edwin vMierlo [MVP]

Hi All, I hope this is not a FAQ. I have a 2-node Windows Server 2003 cluster, with SQL Server 2000 SP3a. This is a development system, and is...

John

07-09-2008 10:32 AM
q

I am just determining the necessary steps to move the system datbases that I have on an Active/Passive cluster. I found the process to do this on...

Russell

07-08-2008 06:56 AM
Russell

Hi, I am trying to run System Performance tool to get statistic for my SQL Server performance. Below are the environment configurations --- OS-...

Nandan

07-07-2008 04:18 AM
Nandan

I need to setup SQL to automatically email out of report each night when it is done, i've done it in the past on a stand alone server by just...

charles18602

07-04-2008 03:11 PM
Ross Mistry

We are having problems with database performance at some of our bigger customers. Our biggest customer has a 1.1 TB database and they are...

Richard Douglass

07-04-2008 04:47 AM
Alex Wilson

The Company I am working for have inadvertantly installed SQL Server 2005 Developer edition instead of Standard edition onto a production...

Steeeveee

07-03-2008 03:23 AM
Ross Mistry

Hi, I have a requirements to deploy SQL 2005 clustering as active/active nodes. We also want to achieve load-balancing. For example, when there are...

chua

07-02-2008 09:25 AM
Riccardone

Is this supported? Details: 2-node Win2008 Ent. Cluster with multiple subnets. Able to successfully fail back and forth no problem with one subnet...

LaRoux

06-29-2008 10:31 PM
Charles Wang [MSFT]

We have a 32 bit SQL 2005 active-active clusterd server, with 8GB RAM in each node. What should we do with boot.ini? 1 /3GB 2 /PAE 3 /3GB /PAE

NT007

06-28-2008 09:13 AM
Riccardone

Hi, i understand that the technology for clustering are N+1 or N+m. However, Can 1 deploy sql cluster nodes in odd numbers? Example, 3 nodes...

chua

06-27-2008 04:05 AM
Edwin vMierlo [MVP]

Hello, I have recently configured two node SQL 2005 failover cluster. I'm wondering if anybody has some king of document/article on how to backup...

Sigitas Skublickas

06-25-2008 02:27 PM
FredS

Hi All, first of all thank you very much for your help! I have two questions I have a SQL Server 2005 on a Windows 2003 failover cluster. Both...

T_M_P

06-22-2008 10:41 AM
Geoff N. Hiten

On Jun 11, 10:30*am, Dannyb <Dan... (AT) discussions (DOT) microsoft.com> wrote: Looking forward to watching the recording, as I couldn't attend...

Uttam Parui[MS]

06-21-2008 03:50 AM
Jiangxi

I am currently involved with a production environment that is made up of a two node Acitive/Passive cluster. I am conscious (and so too of course is...

John

06-19-2008 03:44 PM
Riccardone

SQL Server 2005 Standard edition installattion. Nodes are pingable from each as well as the cluster resource. Installing from a local...

Boris

06-18-2008 12:35 PM
Boris

Anyone have any ideas why a SQL 2005 active/active configuration, would be noticibly slower than if I move one of the active nodes to the other and...

Kevin A

06-17-2008 01:57 PM
Kevin A

Hi, I have added a new sql cluster drive resource into my cluster and brought this online succesfully. However, SQL still cannot see this drive when...

Brian H

06-17-2008 11:05 AM
Geoff N. Hiten

is there a newsgroup which supports SQL Server 2008 failover clustering based on RC0?

RKM

06-17-2008 11:04 AM
Geoff N. Hiten

how do i load balance sql servers? active/passive is not going to do it as 1 node is not able to handle the load

joey

06-16-2008 12:18 PM
Riccardone

Hmm, this is domain account with local admin right. So my situation looks as follow: cluster failed over from 1 node to other and after that proxy...

Karolina

06-16-2008 10:31 AM
Karolina