Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance....

willie

08-26-2004 04:12 AM
Simon Hayes

Win2003, SQL2000 Sp03a We have had several cases of a DTS package failing where it appears that the dtsrun process dropped dead in its tracks. Anyone...

Jim Trowbridge

08-25-2004 08:22 PM
Jim Trowbridge

Hi Uttam, I was not around for a while. Thanks for the help, will go through them. Regards Chip p

Chipsin

08-24-2004 09:25 AM
Chipsin

I have multilple web servers running classic asp and asp.net applications that all connect to a single MS SQL2000 database server with multiple...

Mike Cooper

08-22-2004 09:53 PM
Mike Cooper

Hi all, in our current environment we have 1 server running sql. After making a review of our disaster recovery strategy and readiness we...

RP

08-22-2004 04:00 AM
Chris Skorlinski

this is an error which i happen to encounter..can you guys help me out here.. cursor type should be :rdopenForwardonly lock type should be...

philipp@axcess.com.my

08-22-2004 03:56 AM
Chris Skorlinski

Please post this to the SQL Server Reporting Services newsgroup: reportingsvcs Chris Skorlinski Microsoft SQL Server Support Please reply directly...

Chris Skorlinski

08-22-2004 03:45 AM
Chris Skorlinski

I have a active/passive cluster with W2K Adv. and SQL 2000. I was having the issue with setting up SQL on the second node. I fixed issue by...

SqlJunkies User

08-22-2004 03:24 AM
Chris Skorlinski

Did you follow the instructions in: Changing the IP Address of Network Adapters in Cluster...

Geoff N. Hiten

08-19-2004 01:24 PM
Geoff N. Hiten

Hi all, Does anyone know if it possible to have active/passive instances of SQL on a single virtual server? I'm thinking not but if anyone has any...

Dave N

08-19-2004 09:48 AM
Tim G-J

So what happens in a 4 node cluster for SQL Server, where 3 nodes are 'active' and 1 is a standby node and 2 of the active nodes fail? cluster has...

Ron

08-19-2004 09:35 AM
Geoff N. Hiten

Another point to consider: If it turns out that the Parameters key is empty (and based on the description of what happened, I believe this is it)...

Adam Freden

08-18-2004 11:53 AM
Rand Boyd [MSFT]

Hi, I can execute the SQL statement (which involved DTC function), in the SQL Server with Clustering service if there is no VPN server inside. But,...

Curtis Kam

08-17-2004 10:51 PM
Curtis Kam

Hi, SQL is cluster-aware, so you install it on shared drive (quorum), correct? Then do data files and program files live on that quorum, or on each...

KALI

08-17-2004 10:22 AM
Geoff N. Hiten

I have an active/passive cluster on Windows 2000 SP4 and SQL is SP3a that gets 17052 EventIDs in the form of: printODBCError: sqlstate = 08S01;...

Cathy Soloway

08-17-2004 09:47 AM

8/16/04 This article, and any updates to it, will also be posted on my discussion forum...

BJS

08-16-2004 08:38 PM
BJS

Did you follow the instructions in BOL under Maintaining a Failover Cluster on how to replace a failed node? SQL can be very picky about changes...

Geoff N. Hiten

08-16-2004 11:11 AM
Rand Boyd [MSFT]

When we create SQL Agent jobs on a clustered machine we always get the physical machine name as the source (originating server). We get the...

Hans Schyldt

08-16-2004 11:06 AM
Rand Boyd [MSFT]

I want to store Database files and Log files for the QA environment on NAS. But I am getting the following error: Server: Msg 5184, Level 16, State...

Mukta Soni

08-16-2004 10:21 AM
Andrew J. Kelly

I am trying to install SQL 2K onto a Win 2003 Ent. Ed. machine to create an Active-Passive node. The installation gets as far as the Remote...

Al

08-13-2004 12:24 PM
Geoff N. Hiten

Buy a bigger server. NLB will split the query load between several servers, but there is no way to coalesce the changes on the back end. Each...

Space is not available in TempDB

08-13-2004 11:23 AM
Geoff N. Hiten

Hi, We are going to configure a 2-node active/passive SQL server cluster using W2003 Server Enterprise. A requirement is that both nodes be a...

08-12-2004 04:34 PM

How do I found if a SQL 7.0 installation is on a StandAlone or a Cluster? In other words is there any equivelant for SQL2K function...

Satish Balusa

08-12-2004 12:05 PM
Satish Balusa

Hi there, Does any know a way of backing up to a share from an sql 2000 active/active cluster. I have no problems doing this for stand alone...

Shaun Buckley

08-12-2004 11:40 AM
Geoff N. Hiten

Is there a limit to the number of databases exposed through a virtual server? I'm looking at porting over 200 databases from 12 different servers...

poul0004

08-11-2004 06:30 PM
Andy Ball

Can SQL server be mirrored between two drives in the same box, and can this be used as a backup strategy? Thanks Vince

Vince

08-11-2004 06:23 PM
Andy Ball

Does anyone know if SQL 2005 will be able to reside in a cluster with SQL 2000?

Denny

08-11-2004 12:25 PM
Denny

I have a clustered SQL installed but never added the Replication feature along with the initial setup. Now I ned to configure replication and...

Jay

08-10-2004 04:08 PM
Uttam Parui[MS]

Hi, In a 2-node SQL Server 2000 Active/Passive cluster running under Windows 2003 Enterprise, can both computers be member if a workgroup (i.e....

08-10-2004 03:30 PM
Geoff N. Hiten

hi everyone I am installing SQL 2000 on a single node cluster but after sometime that the virtual server resource installation message shows up, an...

Alireza G.

08-10-2004 05:00 AM
Alireza G.

Node A and Node B (sql server 2000) are being replicated to each other serving data partitioning. What are the options to set up HA clustering and...

Wen Chang

08-09-2004 12:30 AM
Rodney R. Fournier [MVP]

In 800 X 600 you can't see the developer Edition column and there is no left and right scroll bar. DOH! I expanded the screen and answered my...

Tony

08-08-2004 03:31 PM
Rodney R. Fournier [MVP]

Hi - Recently I added some additional memory to a sever thats part of an active passive cluster (for a total of 8GB). After which we started...

Brad Baker

08-08-2004 02:42 PM
Brad Baker

Hi, Our customer has is runnning SQL server standard and they have clients that access the database. We are moving them to SQL Server Enterprise in...

08-06-2004 03:40 PM
Geoff N. Hiten

Hello: I have two server which I want to configure as an Active/Active cluster. In doing so, I am trying to determine all the necessary IP addresses...

Rob

08-05-2004 06:35 PM
Rodney R. Fournier [MVP]

Question about SQL cluster We currently have a SQL cluster with two nodes (active/passive). The transaction logs are currently on the same RAID...

Adam Freden

08-04-2004 03:05 PM
Geoff N. Hiten

Hello, I have a table in my SQLServer1 (SQL2000) this table has a Trigger For Delete The content of the trigger is: insert into...

AA

08-04-2004 02:21 PM
AA

What are the gotchas of adding extra disks to an existing active/activ cluster. Thanks Bolo Allan Hirt wrote: - Bol

Chris

08-04-2004 01:06 PM
Geoff N. Hiten

I have two questions regarding SQL Server Monitoring: 1. How can we differentiate between standalone SQL Server and Clustered SQL Server? 2. How can...

Ritesh Gupta

08-03-2004 08:49 PM
Uttam Parui[MS]

Make sure that when you are running SP3 setup, on the first screen titled "Computer Name", you select "Local Computer" (By Default, "virtual server"...

Uttam Parui[MS]

08-03-2004 08:40 PM
Uttam Parui[MS]

I have been installed a cluster SQLSERVER1 and SQLSERVER2\SQL2 When SQL1 fail, SQL2 take the SQL instance and vice-versa My Problem is that the...

AA

08-03-2004 04:42 PM
AA

Hello, I wanted to bring to your attention a new helpful SQL tool that's coming out. It enables you to run a search & replace throughout your entire...

News.microsoft.com

08-02-2004 09:54 PM
News.microsoft.com

A failover is exactly the same as an unexpected SQL server stop and restart as far as the client can tell. So, all connections are lost for a...

Geoff N. Hiten

08-02-2004 07:42 PM
Mike Epprecht \(SQL MVP\)

Posting to groups again.. Can someone give me a list of outside vendors that help support High Availability of SQL across geographically dispersed...

Hassan

08-02-2004 02:23 PM
John Toner [MVP]

I would like to add a VB Script to the SQL Cluster so that in the event of a failover the script will execute on the new active node. The script goes...

Rodney

08-02-2004 02:20 PM
John Toner [MVP]

I was at a bbq party last night, and one my close friends, a senior lead developer with tons of MS certs from MCSD to MCSE and author of a...

Scott

08-02-2004 10:09 AM
Andrew J. Kelly

What is the best method for moving databases from one server onto a clustered setup? Obviously you can use backup/restore or detach/reattach. What I...

Bill

07-30-2004 01:39 PM
Geoff N. Hiten

I think your developer misunderstands the whole 'active-passive...' nomenclature. Do you want one or two virtual servers on your cluster? If one,...

Allan Hirt

07-30-2004 12:45 PM
plane123

SQL 2000 (no service pack installed yet) on Win2000 My newly configured failover cluster is experiencing sudden stops of the SQL Server service and...

XY

07-30-2004 07:43 AM
Rodney R. Fournier [MVP]

I can tell you, there is no way other than uninstalling and reinstalling that will do it correctly and properly. Remember that just restoring master...

BarryLynch

07-30-2004 05:58 AM
BarryLynch