I have a few existing 2000 instances that we are migrating to 2005 SP2. The instances have a lot of databases on them. Is there an easy way to...

Charlie

11-27-2007 07:51 AM
Charlie

I am trying to add 2 2005 nodes to an existing cluster that has 2xSQL2000 nodes. The cluster is using a SAN with - T, U drives as data and log in...

Geoff Tanner

11-26-2007 10:05 PM
Linchi Shea

Hello everybody ! I hope this is the right place for my questions. I would like to know whether there is a possibility to make available the same...

ernest

11-26-2007 07:35 PM
Rick Heiges

You guys just posted that there is no true Scale Out technology with SS. But I am curious: does MS have anything in the works? Are there any...

CLM

11-26-2007 06:21 PM
CLM

I've been reading my Sql Server 2005 Maintenance and Implementation book on Mirroring and Michael Hotek gives an example of a client that...

CLM

11-26-2007 05:19 PM
Geoff N. Hiten

Hi all, Just hoping that someone could shed some light on something strange with profiler. I'm doing some performance and bottleneck testing of a...

Andrew Hayes

11-25-2007 08:37 PM
Andrew Hayes

I have a 2 node (Active/Passive) SQL cluster running on 2 2003 nodes. I want to upgrade this cluster to a SQL 2005 cluster. I know that I can do a...

Amy Lewis

11-23-2007 12:19 PM
Amy Lewis

I plan to create a cluster with 2 nodes. i will configure a virtual server name and ip for the public client access. is it possible to define a...

Thomas Niemann

11-22-2007 11:02 PM
Tom Moreau

How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?

DR

11-21-2007 05:49 PM
Andrew J. Kelly

Hi, We are looking into implementing an Active:Passive SQL 2005 Cluster for a reasonably large and important system (< 1Tb) I'm not looking for...

craig_amtdatatechnologies@discussions.mi

11-21-2007 02:35 PM
Aaron

Hi, I have SQL 2005 server (with Named Instance) running on a two node Cluster Configuration (Active/Passive). SQL Instance, SQL Server Agent, SQL...

Mehul

11-20-2007 10:01 PM
Linchi Shea

Hello I will setup a 2 node sql 2005 std. ed cluster with multi instance. How maney instance can i run (16 total in standard ed.) ?, there is a...

CK

11-20-2007 09:37 PM
jason

Are the servers you are connecting to runing 32bit SQL? If so, that's the...

Gotcha

11-20-2007 05:41 AM
Gotcha

Hi All, I have a two node cluster, and need to add a third node, can anyone please send me a link, or steps on...

achilles silva

11-20-2007 03:14 AM
achilles silva

Sorry for the repost... thought it better to put in a message of its own... We have installed SSIS in a cluster. We have a test package setup,...

Chris

11-19-2007 07:44 PM
Chris

Suppose I have SERVER1 and SERVER2 with database DB1 and DB2 in both servers with database mirroring enabled for both databases. If I'm connected to...

Jazmin Gutierrez

11-19-2007 11:34 AM
Mohit K. Gupta

You can not do this The limitation is NTFS, NTFS you can only have on server accessing the volume at a time. You can not do this on the same host...

Linchi Shea

11-18-2007 06:00 AM
Edwin vMierlo [MVP]

Our env: SQL Server 2005 Ent SP2 64-bit, two-node single-instance failover cluster, Win2003 Ent SP1, 16GB Here's our problem: The startup parameters...

salsafreak

11-16-2007 07:20 PM
salsafreak

Hi, I've install an SQL 2005 cluster (Database engine and analysis services, same group, default instance) During setup I chose to add an IP of my...

Hugues Sauvage

11-15-2007 12:39 PM
Hugues Sauvage

Hi, I am installing sql 2005 on a two node cluster. I have managed to complete the installation and then wanted to add the sql management studio on...

Paul

11-15-2007 09:23 AM
Geoff N. Hiten

Hi, I am about to install sql 2005 in a clustered scenario. I am reading the installation notes and it says : On the Cluster Group Selection page,...

Paul

11-15-2007 09:20 AM
Geoff N. Hiten

Im working on sql consolidation project and I am about to build multiinstance 2 node cluster. If I want Integration services installed should I...

=?Utf-8?B?RWxsaWU=?=

11-14-2007 07:06 PM
Chris

Guys, I have a “small” problem with SQLBrowser. A setup is very simple: 3 nodes 2K3 R2 SP2 x64 cluster with 3 named SQL instances (x64 too). The...

OK

11-13-2007 01:14 PM
OK

Hi everybody, I'm having a big problem when I want to rename my Failover Clustered SQL Server 2005 Virtual Server. I've followed the indications...

news.microsoft.com

11-12-2007 12:56 PM
Tom Kretzmer

How can we convert our SQL Server 2000 (Windows Server 2003 R2) Active\Passive cluster to Active\Active? Thank you. -- Mike

Mike

11-10-2007 06:56 AM
Tom Moreau

I have an active/passive SQL 2005 cluster consisting of 2 nodes. My bosses want me to rename both nodes and also move the cluster to a new domain....

Tony Dawson

11-10-2007 06:51 AM
Tom Moreau

If I configure a director-class SAN with RAID 10 for the actual storage with enough and more space, is it safe to assume that I can store all...

Hotmail User

11-10-2007 01:27 AM
Linchi Shea

We have a consultant setting up a SQL 2005 Cluster. This person is asking for a temporary domain administrator account for the installation. He...

Babooze1

11-08-2007 11:06 AM
Geoff N. Hiten

Hi Despite being directly connected with a crossover cable and each server being connected in to the switch, they seem to think that they need...

David Morgan

11-07-2007 05:38 PM
Tom Moreau

Hi, I'm trying to install SQL 2005 on a Windows 2008 cluster. I just want to know if this is supported, and if there's any special...

Usentr

11-07-2007 02:51 PM
Geoff N. Hiten

oops, post should have gone to this forum ..... Hi, I read in the SQL 2005 Exam guides for clustering that (p.283 - 70-443), that if building a...

craig_amtdatatechnologies@discussions.mi

11-06-2007 10:25 AM
craig_amtdatatechnologies@discussions.mi

I have a SQL 2000 2-node cluster that is working fine. In a few days they will be changing the networking on the network where this cluster is...

Amy Lewis

11-06-2007 09:22 AM
Geoff N. Hiten

SQL Server 2000, Windows 2003 R2, Cluster 5.2 We're setting up a new cluster and I would like to move the LOGFILE and SQLAGENT.OUT file off of the...

Jay

11-05-2007 11:49 PM
Jay

I have a three node cluster with three virtual sql server 2005 installed. Now I want to take one node out of cluster to make a two node cluster....

dp

11-05-2007 12:03 PM
danieldong

Helo, i install and configure database mirroring in SQL 2005 with automatic failover. Client aplications use ADO.NET or the native SQL Server...

Peter

11-05-2007 09:30 AM
Peter

We actually replaced the controller card on one of our clustered servers (was the system controller not SAN controller). Ever since then we have...

Kat99

11-05-2007 08:48 AM
John Toner [MVP]

We have 1 current Windows 2003/SQL 2000 Cluster (CL1). We are purchasing 2 more servers that are targeted to replace (CL1) for performance...

Mark

11-01-2007 04:49 PM
Russ Kaufmann [MVP]

Hi Experts, I have a customer running SQL Server 2005 and his database's are on the physical server. We would like his entire database only on the...

Girish J Bhatia

11-01-2007 12:02 AM
Girish J Bhatia

Hello there Here is question i got: I have sql server 2005 failover clustering. On node1 someone has run procedure which update data on huge table...

Roy Goldhammer

10-30-2007 08:13 PM
Linchi Shea

I am testing an active/passive cluster running W2003 and SQL 2005 SP2. What I try to test is: Power down one node and then on the active node...

danieldong

10-29-2007 01:49 PM
Rodney R. Fournier [MVP]

Hi, Can someone give me an opinion with installing SQL Server 2005 with clustering and use those servers for file servers at the same...

Jacques Demers

10-26-2007 11:34 AM
Jacques Demers

I have built two new SQL 2005 clusters on Windows 2003 R2. I have the lastest services packs on for both and I have remote connections and named...

Scott

10-25-2007 02:34 PM
Scott

....has anybody tried this? ... I need to install the 10g client on a cluster virtual server so that I can use integration services to pull data from...

news.microsoft.com

10-24-2007 11:34 PM
Linchi Shea

I have sql 2005 installed with sp2. I have an external file server with 1 terribyte of space. I want to have my data and log files on the...

john

10-24-2007 03:25 PM
Linchi Shea

Hi, Can we use Majority Node Set to run SQL Clustering. If yes, Can anyone provide me the step by step guide to do this. Thanks Neeraj Mehra

Neeraj

10-24-2007 08:34 AM
Geoff N. Hiten

We have a 2 Node SQL Cluster that I was trying to upgrade to win2k3 from win2k. In the process the cluster got completely corrupted. I followed...

VBeachcomber

10-23-2007 05:29 PM
Geoff N. Hiten

Hello, We have two servers configured as a sql2k cluster as well as two domain controllers on our network. This cluster was created years ago and...

Blackgoo

10-23-2007 03:48 PM
Blackgoo

Hi all, I perfectly well understand how to create a SQL 2005 cluster. So I have a 2 node Cluster Active/Passive, on which i have SQL 2005 installed,...

jetoo

10-23-2007 12:02 PM
Linchi Shea

Hi, I am in the process of upgrading our servers from win2k to win2k3 SP2. We have a 2 node failover cluster services confg for sql2k. So while...

VBeachcomber

10-23-2007 10:22 AM
VBeachcomber

Hi! I have two Windows Server 2003 Enterprise servers configured to an basic cluster. I want to install SQL 2005 on this servers to get high...

Christoph Duesmann

10-23-2007 09:55 AM
Uri Dimant