In a multi-instance cluster, how can you match a named sql server instance with an instance of sqlservr.exe? When setting up counter collection...

Denise

05-17-2005 02:41 PM
Denise

Dear All, I would like some assistance in an issue we have had, around a week ago we had a network failure, where our Active/Passvie Cluster failed...

Keith

05-17-2005 06:54 AM
Keith

Hi, I have been setting up a WIN2K3 Cluster here today and having some problems. I can get SQL Installed ok and everything works fine until I set my...

Dan Sadler

05-16-2005 01:03 PM
Carlos Selonke

I've build a SQL 2000 SP3a cluster on top of an 8 node Windows 2003 cluster. We've decided to split the cluster up into 2 individual clusters and as...

Chris B.

05-16-2005 12:37 PM
Mike Epprecht \(SQL MVP\)

Hi everyone We have 2 cluster servers and each server has 3 instances (under WINDOWS 2003), all these is under a...

Carolina Garcia

05-16-2005 11:41 AM
Mike Epprecht \(SQL MVP\)

How is best performance and support.?

Lynce

05-13-2005 06:17 PM
Mike Epprecht \(SQL MVP\)

Hi everyone, First please excuse my ignorance. I am a consultant and generally work with small business servers and I have no experience with...

Brian Z

05-13-2005 09:02 AM
Andrew J. Kelly

Hello! First excuse me for my english. J have a cluster windows 2003 EE , and j have installed an instance non virtual in the first node, with...

Giordano_damico@hotmail.com

05-12-2005 07:05 PM
Giordano_damico@hotmail.com

I have 2 Windows 2003 servers running SQL2000. They each have separate databases. I am in the process of clustering these 2 machines together. ...

Amy Lewis

05-12-2005 04:54 PM
Cindy Gross

I am running a 3active/1passive node cluster on W2K3 and SQL 2k. The passive node has the ability to have any of the active nodes to failover to it....

Thom

05-12-2005 04:16 PM
Cindy Gross

Hi, How can I know how much memory is used by SQL Server in Cluster? as I believe on nodes I cannot see that. thanks in advance

Muhammad Akhter

05-12-2005 04:07 PM
Muhammad Akhter

Hi, For clustered servers we only see Named Pipes and TCP/IP as available Protocols. VIA is disabled. Are there any other protocols that we can run...

Chris Wood

05-12-2005 09:58 AM
Chris Wood

I have a cluster SQL 2000 server running on Win2003 Because of a connection error, i found an...

mike

05-11-2005 10:38 AM
mike

I just started looking into SQL replication can anyone please direct me to some KB docs that I can read up on? Thanks

Peretz Stern

05-10-2005 10:20 AM
Kevin3NF

Hi GUYS, I am setting up a sql cluster on win 2003. i am using distributed transaction so using MSDTC. as far as i know WHILE Clustering MSDTC we...

bijupg

05-09-2005 05:20 PM
Rodney R. Fournier [MVP]

Does anyone know how to get the cluster name to be registered in AD? I only see Node1 & 2... but not the virtual. Thanx Chris

Ooroster

05-09-2005 02:02 PM
Ooroster

I need to move my cluster out of a domain and into a workgroup. Is there any documentation available on this procedure? So far an online search has...

Scott

05-09-2005 12:19 PM
John Toner [MVP]

Hi, We have a processes which is completed in 3 hours on a machine with scsi hard drives with data on RAID 5 with 4 hard drives and log on a...

mna

05-06-2005 05:18 PM
Mike Epprecht \(SQL MVP\)

Hi, We have W2K/SQL 2000 Cluster server (Active/Passive mode) and attached to NT domain. We want to move this to AD Domain. Is there any Microsoft...

Karthi

05-06-2005 11:04 AM
Rodney R. Fournier [MVP]

My user wrote asp apps previous ran fine against SQL 2k sp3a on win2k. Now we upgrade our SQL server to Windows 2003 Failover Clustering SQL 2k...

Maggie

05-06-2005 06:01 AM
Peter Lykkegaard

Hi all, I was wondering if any of you could offer me some help with my cluster. I've been dropped in the deep end and currently experiencing a...

Horseman_UK

05-06-2005 05:36 AM
Peter Lykkegaard

Hello to all, I'm investigating an application outage issue on a 2-node W2K Adv Server cluster. A Generic Application is running on the cluster in...

Chris

05-05-2005 08:10 PM
Krissi

I was wondering if any of you could offer some help with my cluster. I'm troubleshooting an existing problem within the company where the...

savvy95

05-05-2005 05:12 PM
Geoff N. Hiten

We are using an Access database with Employee Pictures. However, we find that the size of the database is pretty large as images are stored as BMP...

Jason

05-04-2005 02:52 PM
Kevin3NF

Hi, Is there any white paper or best practice for laying out a SAN running SQLServer. My client has a new clustered HP EVA SAN and we are looking...

liam.caffrey@gmail.com

05-04-2005 08:51 AM
liam.caffrey@gmail.com

Hello - We are considering implementing a clustered SQL scenario over 2 different datacentre locations. At the moment we are thinking of...

Ian Rogers

05-03-2005 06:55 PM
Mike Epprecht \(SQL MVP\)

Hi all - i am fairly new to clustering and here is what i am trying to accomplish: - 2 DL380 g4 with 5 drives each. - 2x Raid 1 for sys files - 2x...

JsX

05-03-2005 06:03 PM
digger

I'm having trouble connecting to a named instance on a SQL 2000 EE cluster (Windows 2003). I have no problems connecting to the first virtual server...

Curtis O. Bouknight

05-03-2005 03:01 PM
joettu

Can someone help? I have a cluster based on 2003 with SQL 2000 sp3a running active / active currently with 2 named instances on each node. The...

digger

05-03-2005 02:51 PM
digger

I've installed Windows Server 2003 EE SP1 Cluster successfully with two nodes and now I'm trying to install MS SQL server 2000 Cluster on it.. as...

Samo

05-03-2005 04:17 AM
StevieRay

Need a SAN/NAS but (by cost) need a software solucition. Suggest?

Lynce

05-02-2005 04:27 PM
Geoff N. Hiten

What is MSDTC and why woud I want it on my W2K3 ent act/pas SQL 2K cluster? Cluster is already setup and virtual sql instance running ok... Thanks

Lapchien

04-28-2005 05:27 PM
Gary Hope

Cluster active-active. The installation in one server was lost and the S.O. was reinstalled. Now in one node there are two instances. How can I...

Shima

04-28-2005 02:56 PM
Geoff N. Hiten

Environment: HP Servers and SAN Win2k3 EE (no SP1 but all WinUpdate patches) SQL2k EE w/SP3a I'm a newbie to this and some questions that I have...

Matt

04-27-2005 10:26 PM
Mike Epprecht \(SQL MVP\)

Hi everydoby, i'm new in this ng :=) I'm also new to cluster and i have little questions. I have 2 node (identical, HP DL380) and a san MSA1500,...

macchianera

04-27-2005 01:38 PM
macchianera

Hi, I am in the process of building a SQL Server "farm," but having to tone down the pace due to $$. I have just purchased a RAID1 (2 disc/10K...

JT

04-26-2005 03:35 AM
Mike Epprecht (SQL MVP)

Hi all I am trying to work out if it is ok to install an antivirus product onto my Windows 2003 SQL Cluster. According to Symantec I...

Krissi

04-22-2005 11:45 AM
Rodney R. Fournier [MVP]

Hi, I have two physical SQL servers running under cluster. When execute a query that returns around 3000 records on one of the cluster...

raypolee@gmail.com

04-22-2005 10:43 AM
LUCA MOTTERLE [MCP]

Hi! I am planiing to install SQL 2000 EE on Win 2003 Cluster: 2 node cluster, Windows 2003 1 SQL Server instance (active/passive) In order to do...

Tom

04-22-2005 10:06 AM
Donna Lambert

I have 2 2003 servers each running a separate copy of SQL. I have purchased a external storage Dell Powervault running RAID 5 to serve as the shared...

Amy Lewis

04-20-2005 04:26 PM
Geoff N. Hiten

Thanks a lot! You helped me, but now I have a few more questions: I am installing SQL Server 2000 cluster (1 instance) on Windows 2003 SP1 1. Do I...

Tom

04-20-2005 12:56 PM
Tom

Can one deploy a 2 node cluster with an instance on each node and the failover node be the other? Like node A & node B, A's instance fails to B and...

John - PDX

04-20-2005 09:54 AM
Geoff N. Hiten

This is probably a hardware issue, but since HP is of no help, I thought I'd post here too. We have a SQL/Exchange 2-node cluster(Windows 2003,...

dathrill

04-19-2005 10:22 PM
Andrew J. Kelly

Hello: Does merge replication support clustering? I'm having some troubles about merge agent "querytimeout" parameter throught a clustered system,...

Juan

04-18-2005 06:06 PM
Mike Epprecht \(SQL MVP\)

I do not have any experience with MS SQL. I'm a hardware engineer. I focus mainly on the servers hardware and connectivity. I was wondering, is it...

Alistair Wong

04-17-2005 10:40 PM
Rodney R. Fournier [MVP]

Hi You have 1 SQL Instance, in a 2 node cluster. Am I understanding you right that you have at any one time SQL Server running on both nodes of the...

Mike Epprecht \(SQL MVP\)

04-17-2005 10:34 AM
Greg D. Moore \(Strider\)

Clustered named instances show up as VirtualServerName\InstanceName. Since the Virtual Server and the Instance have the same name your system...

Geoff N. Hiten

04-15-2005 05:18 PM
KellyVV

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1...

Vanessa Lee

04-15-2005 11:43 AM
Kalen Delaney

Removing fragmentation is a good thing to do in general anyway. If you used Indexdefrag the statistics will not be updated so you want to...

Mike Epprecht \(SQL MVP\)

04-14-2005 03:06 PM
Andrew J. Kelly

Hi All, I built a SQL Cluster in a dev area next to my cube. Had two web servers pointing at it and everything was working perfectly. I picked up...

CJ Butcher

04-14-2005 02:01 PM
Rodney R. Fournier [MVP]