Hi all, Is it possible to place the tempDB on internal disk and the data on SAN? Please help.... Many thanks

Tedi

03-10-2010 03:17 PM
Geoff N. Hiten

I cannot diasbale the VIA protocol and get the primary SQL instance to start in my Virtual Cluster the Attributes of the Server configuration is as...

Dennis

03-10-2010 02:07 PM
Dennis

The SQL cluster is not failover over to another node. Can anyone shed some light in to this. I have checked the config on the cluster administrator...

Praful Varsani

03-10-2010 10:46 AM
Geoff N. Hiten

I am running SQL Server 2005 x64 on Windows 2003 active/passive cluster. We are currently having latency issues with our SAN, this is causing the...

Jim Clark

03-02-2010 10:13 AM
Pat Klein

Can anyone suggest a best practice for maintaining cluster.log history? I know there are environment variables that control the log size and a...

Will Banta

02-25-2010 10:06 PM
Will Banta

Hi We have a 2-node cluster running Enterprise x64 SQL 2005 on W2K3. We wish to install additional instances to assist management. We intend to...

Steve

02-25-2010 10:21 AM
Geoff N. Hiten

Everyone, I have configured a SQL 2005 cluster with two nodes. My SQL data is on a SAN attached drive managed by NetApp which is drive x:. When I...

Amador

02-23-2010 11:16 AM
Geoff N. Hiten

Good morning, all - Two node SQL 2008 cluster attaching to SAN storage. Dual path software in place on both nodes. On a failover attempt (planned or...

GaTech_Geek

02-22-2010 02:39 PM
RCan

Is anyone aware of a utility or a script that is available that would allow an automated failover of a SQL Server Virtual Cluster Resource Group...

tom

02-22-2010 03:41 AM
Charles Wang [MSFT]

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-17-2010 08:11 PM
Mia

I've set up our first sql2k8 cluster on w2k8 r2 and it works as expected. Now I got a funny experience with the firewall. As I want it the firewall...

Peter Lindberg

02-16-2010 02:00 AM
Peter Lindberg

Hi i upgraded sql server 2000 sp4 active/passive cluster (windows 2003 sp2) and got into issue. Ran the upgrade on active node and the node...

krishna

02-12-2010 05:51 PM
krishna

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

02-07-2010 06:00 PM
antivirus gratis

We have an active-passive cluster environment with Windows Server 2003 and SQL Server 2005, where the MSDTC is working correctly, in the...

Elmo

02-06-2010 07:04 PM
Geoff N. Hiten

I think I discovered a BIG problem with Windows 2003 x64 R2 SP2. Suppose I set a setup a server and connecting it to a SAN disk and then format this...

Gaspar

02-05-2010 01:32 PM
Geoff N. Hiten

We have 2- node Windows Enterprise 2003 x64 servers clustered in active/active configuration with SQL 2005 x64 installed on it. Both servers are...

Dovla

02-05-2010 09:06 AM
Dovla

Hi All Application uses ASP.Net 2005 and SQL server 2005 We are connecting to the web application from a local machine. When we click a button on...

hems

02-03-2010 02:44 AM
Uri Dimant

Hi, I'm running 4 instane SQL Server 2005 in an active/passive clustered enviroment utilizing a SAN. I'm running out of space on one of my LUN's for...

d7

02-02-2010 05:14 AM
d7

I am looking to implement SQL Clustering on a SAN with SATA drives. While I know that clustering is not a "performance" solution, however...

John

02-01-2010 06:57 PM
Andrew J. Kelly

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

02-01-2010 02:55 PM
Mia

we would like to setup the SQL DB using windows cluster, is it a must to have external storage ? the 2 server have Raid 5 configure, can we...

DD

01-30-2010 11:13 PM
daveberm

All, SQL Server 2005 EE SP3 CU1 in an active-passive failover cluster configuration. Whenever I fail over the cluster or restart SQL Server, the...

Ant-nee

01-29-2010 11:45 AM
Ant-nee

Muchos problemas de rendimiento y seguridad de tu computador son causados por virus maliciosos, la mejor forma de combatir esto es tener instalado...

antivirus gratis

01-29-2010 08:36 AM
antivirus gratis

hi i have an active/passive sql sever 200+sp4 cluster and i need to upgrade it to sql2008 cluster. the BOL is saying " to run the setup on...

krishna

01-28-2010 02:38 AM
kpxus via SQLMonster.com

Hello, I am trying to install a MS SQL SERVER 2005 64 Bits in cluster, but when the process is finish I get this error (Microsoft SQL Server 2005...

mike

01-27-2010 08:10 PM
Geoff N. Hiten

having an issue installing a 2nd instance on a 2005 sql cluster running on win2008 R2. It may be simple since i've never done this on 2008...

ccinatl

01-27-2010 08:08 PM
Geoff N. Hiten

Hi all, I am new to Windows and SQL Server clustering. I want to install Windows 2008 on two servers and have two SQL Server 2008 sp1 clusters. Each...

Preethiviraj Kulasingham

01-26-2010 10:28 AM
daveberm

i need a quick way to provide failover for my sql server. i just want to have a backup ready to go if server A fails. i will have only two servers....

mcnewsxp

01-25-2010 08:49 PM
Geoff N. Hiten

I have a 2-node SQL Server 2008 cluster. S:\ is the shared drive for the SQL Server cluster group. Can I create an INETPUT folder in S:\ for IIS? Is...

Gaspar

01-21-2010 02:09 PM
Geoff N. Hiten

I'm seeing some issues on a Two Node cluster (majority + disk). Failover works GORGEOUSLY. No problems. They go like a volleyball game. But when...

Robert Hindla

01-21-2010 02:09 PM
Geoff N. Hiten

I am working on design/testing of a large sharepoint site, on the DB side is there any downside to using a mix of shared storage rather than one big...

John

01-19-2010 05:29 AM
Edwin vMierlo [MVP]

Many computer problems are caused by viruses and malware on your computer. The best and easiest way to correct this is to use a recognized antivirus...

antivirus gratis

01-15-2010 06:46 PM
antivirus gratis

I have a SQL 2005 cluster, 2 node, running on 2003 Server, all patches/ sp's up to date. It was working fine until yesterday. We installed Reporting...

John

01-13-2010 08:42 PM
Geoff N. Hiten

Hi All, My company is looking to build a scalable, high availability SQL Server 2008 instance. I've been searching online to find definitive...

jimjawn

01-13-2010 02:14 PM
Tom Moreau

Trying to install SQL2K8 Failover Cluster on 2 Node Server 2K8R2 Cluster fails in section "Instance Configuration" with the following...

Andreas Scharin

01-13-2010 09:06 AM
Geoff N. Hiten

How do we add a new Named Instance under Services and Applications for the existing SQL 2008 Cluster? We have the default MSSQLServer installed...

John Myren

01-06-2010 10:54 AM
Geoff N. Hiten

I need to know the active node in case of clustered SQL 2000 from any of the participating nodes for a particular SQL Server instance. A shared...

v_2ankp

01-06-2010 10:51 AM
Geoff N. Hiten

Does anyone know how to prevent a cluster group from starting. I have a situation whereby I have several standby groups that have resources that...

Mark Broadbent

01-06-2010 10:18 AM
John Toner [MVP]

I have an application that would like to know which is the current active node name in SQL 2000. If I use 'cluster clusterName res resourceName ' to...

Joe K.

12-24-2009 01:12 AM
v_2ankp

I have an application that connects to SQL Server clustered instance and works based on the fact whether it is installed on active SQL node or...

v_2ankp

12-24-2009 12:57 AM
v_2ankp

Dear All, While adding second Node into Named instance in SQL 2008 x86 Ent. Clustering we are getting error "FailOver Instance "ABCD" cluster group...

Dinesh Bhandare

12-22-2009 08:44 AM
Geoff N. Hiten

We are a SQL 2008 std 64 bit on windows 2008 enterprise 64 bit shop and use two node active passive clustering. Currently our heartbeat network is...

OceanDeep via SQLMonster.com

12-22-2009 05:30 AM
Mark Broadbent

The management studio didn't get installed on our new two-node cluster. When I try to do 'add feature', via 'new standalone or add features',...

s_m_b

12-22-2009 05:29 AM
Neil Matthewson

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

12-17-2009 10:29 AM
Mia

Hello, System config: SQL2005 Enterprise in Windows2008 Cluster 2 Nodes 1 SQL- Instanz ca. 20 DB's Is it possible to change Sql2005 Enterprise to...

bienchen

12-15-2009 10:44 AM
Geoff N. Hiten

Hello! We will be installing SQL Server 2008 64 bit EE on Windows 2008 EE (Active/Active cluster). I would like to confirm following...

Igor Marchenko

12-14-2009 06:08 PM
BrentM

I am configuring a 2 node windows 2008 failover cluster for SQL 2008. I want to put three instances in the cluster. Is it a better design to...

Go Oilers

12-13-2009 02:49 PM
Geoff N. Hiten

I didnt install or configure the cluster but it appears to be setup correctly per Microsoft standards. Now I'm attempting to test the failover of...

Rich

12-13-2009 02:48 PM
Geoff N. Hiten

Hi ! I wonder if it is possible to have standard and enterprise edition installed on the same kluster , Sql-server 2005, windows 2003 enterprise...

Ulf Fernholm

12-11-2009 02:27 AM
Ulf Fernholm

SQL Server and SQL Server Agent service cannot start on third server. We have 2- node Windows Enterprise 2003 x64 servers clustered in active/active...

Dovla

12-04-2009 04:32 AM
Dovla