Hi, I have two node with one shared SQL Server Database. Now I have to schedule backup for the above Database. In this case what will be the best possible solutions? Thanks in Advance. Ashok...more >>

Hello, I have a SQL Server 2000 cluster running on Win2K (2 HP ML530's on an HP MSA1000 SAN - all 14 drives in one RAID array). I recently added some unallocated disk space on the SAN as a new disk resource in the cluster. The MSA1000 doesn't support extended partitons so a new partition ...more >>

Hi, I am trying to determine the best method for rebuilding some existing Windows 2000 clusters to Windows 2003. I have both SQL clusters and some application clusters. I do not want to upgrade the OS, but rather rebuild from scratch, one node at a time, using the existing hardware. Is this p...more >>

I am running a 2-node cluster for SQL Server. After powering down both servers (passive then active), one of the nodes did not successfully join the cluster. This node shows exclamation marks on the Network Interfaces in Cluster Administrator. These nics are functioning correctly outside of ...more >>

I am new to clustering. I have read all of the Windows Server 2003 clustering documentation. Can someone direct me to a Microsoft document on installing SQL 2000 Failover clustering in a Windows Server 2003 environment? I see papers for SQL 2000 in Windows Server 2000. Should I use those ...more >>

Hi, I am running SQL2000 (SP3 applied) on a cluster running in Windows 2003. I have 2 problems: I am either unable to run a backup from a maintenance plan, or I am unable to failover to the other server. According to article http://support.microsoft.com/default.aspx?scid=kb;en-us;815431&Pr...more >>

When: Tuesday, November 30, 2004: 10:00 AM Pacific time (Greenwich mean time - 8 hours) For more information and powerpoint slides, please refer to http://support.microsoft.com/default.aspx?scid=kb;en-us;888121 I hope you enjoy the broadcast! Best Regards, Uttam Parui Microsoft Cor...more >>

Hi, I need a solution to perform load balancing on my OLTP database, for example between two servers. Any help would be greatly appreciated, Leila ...more >>

I'm having a problem with the node name on SQL2K jobs on a veritas cluster. We are using named instance on the sql server. All the jobs I create are getting a source of node1\instance. This causes a problem if the cluster fails to node2. However, if I change the originating server in the sysj...more >>

I have a stored procedure written for number of updates, inserts to the database. This stored procedure takes too long to run. I have created few indexes around few tables, but the response time is not that defferent. THere is a Curser "CURSOR FAST_FORWARD FOR" in the stored procedure, and ...more >>

Hi, I am using Windows 2003 Server. The VPN works fine, but I want to FTP through the VPN so the connection is encrypted. The problem is each of my IIS sites has a real Internet address specified, w.x.y.z. So when the VPN comes up using a private IP, I can't connect to any of the FTP sites u...more >>

What's the best physical drive configuration for a SQL cluster on a SAN? Would creating a large (14drive/2buses) physcial RAID 1+0 array with appropriate sized LUNs be acceptable for the quorum, tempdb, ms-dtc, and sql tlog shared resources? Or would individual mirrored drives defined as L...more >>

please help on this error i was installing SQL Server 2000 ENT on Windows Server 2003. Cluster. after assignin the VirtualServer Ip the Setup stoped and generated an event in the event viewer." Event ID:1000, Faulting Application_INS5576._MP, version 5.53.168.0, faulting module sqlsui.dll, ve...more >>

We currently have two W2K Enterprise servers running MSCS and each of these is running MS SQL2000 enterprise. The Cluster is Active/Active and we have a single instance of SQL running on each server. The question I have is would it be possible to add another Instance of SQL on both Boxes...more >>

I have 2 DELL Windows 2003 Enterprise server machines with SQL 2000 Enterprise Edition and 1 PowerVault 220S SCSI Array set in Cluster mode hooked up to both of these machines. I want to know is it possible to use this configuration with SQL in a ACTIVE / ACTIVE state. By Active/Active, ...more >>

I can't perform a distributed transaction between a remote server to the central server. I have 3 sql server 2000 enterprise edition. 2 of them are installed on win2K server (LOCAL1, LOCAL2) and the other (CENTRAL_SQL) is installed on clustering win2K server. None of them is in domain. ...more >>

All, We have just rebuilt a SQL 7.0/NT cluster with Windows 2003/SQL2000 in an active/passive configuration using 2 nodes. During the course of testing it we had a general network failure in which the network was unavailable. The virtual SQL and Windows IP address resources went down a...more >>

I'm designing a 3 node cluster that will be running SQL Server and Exchange in an Active/Active/Passive configuration. The cluster will be using a small SAN for storage (HP MSA 1000). The first active node will run SQL. The 2nd active node will run Exchange, and the 3rd passive node will be ...more >>

Win2003 SQL2000 Active/Active On node1 SQL service shuts down and immediately restarts. In the cluster log on node1 we found the following below at exact time of service stop/start. Why would a failover not have occured? Why is CheckQueryProcessorAlive prefixed with ERR SQL Server..., t...more >>

Hi We have a client that wants to implement a SAN to be shared by other servers. How do you setup a SQL server to use the SAN array? The client only has one SQL server (node). I have implemented SQL onto Active/Active and Active/Passive clustering before, but i am confuse to just h...more >>

Hi, As far as I know, clustering is used to increase availability of SQL Server. Is it possible to benefit from clustering for performance (load balancing or...)? Thanks in advance, Leila ...more >>

I have a two node MS cluster. I have sql 2000 and Windows 2000 advanced server. What are the steps to applying service pack 3a? I have read KB 330022 and KB811168 and neither one give detailed steps to the order and how it should be done. All help is greatly appreciated. Thanks. ...more >>

Hello, is it possible to manage cluster resources with a script language like Visual Basic? I want to update the cluster applications with an automatic installation process. Therefore I must stop the corresponding cluster resource (take offline), update the application and restart the cluste...more >>

I have 2 nodes Cluster Active/Passive on Windows 2003. When I reboot either one, it comes fast no problem but when I logon to the node it takes 15 minutes waiting on "Applying Computer Settings" message then it will show the desktop. I didn't install SQL 2000 yet, I need to solve this issue be...more >>

Is it possible to have a node that is running one default and one named instance of SQL Server 2000, A second node that's running a default instance of sql server 2000 and have both failover to a third node? Any thoughts, suggestions, or answers would eb appreciated particular if your're curr...more >>

O.K., Dumb question, but I'm not a SQL guy. I've been tasked with upgrading our SQL environment from a single server utilizing an external storage array to a clustered environment using 2003 Server. The question is, with SQL already running on the original server, won't I have to reinstall SQL...more >>

We have a clustered SQL Server 2000 sp3. There are two nodes, and only one database (20GB). We back up the db's transaction log periodically throughout the day, and truncate the log with a full backup every night. We can back up the transaction log to disk on another server without problem...more >>

Dear All, I have a 2 node SQL cluster connected to SAN storage via fibre channel. I am getting warnings in one of the SQL node in the system under event viewer. Following is the warning i am recieving on the server :- Event ID :- 8021 Source :- BROWSER The browser was unable to retrie...more >>

We have a SQL cluster in our development lab that was installed using the "ent" directory on the MSDN disks. We also have a SQL cluster in production that was installed using a retail version of SQL enterprise. We we went thrught the steps to change the IP of the SQL cluster, we noticed that th...more >>

I have a SQL Server 2000 Cluster with Windows 2003 Server what resource should MS-DTC depend on? Thanks,...more >>

When installing SQL 2000 on a W2K3 cluster, I get the following error: An error occurred while creating virtual server resources for clustering. Cluster specific registry entries couldn't be written. I followed the instructions in KB872931 and I get the same results. Can anyone assist? Kev...more >>

Hi All Gurus I am trying to install SQL2K on Win2003 Ent.Ed. I could successfully configure MSDTC as a resource , then i tried to install Sql Server 2k (Ent Ed), After i provided all the information like ip name, n/name all off a sudden , istallation failed saying cannot continue . I checked,...more >>

I forget to set Client Network Utility to Create a Named Pipes Alias for installation of a named instance of SQL Server 2000 virtual server on a Windows 2003-based cluster fails to push binaries to the other node. SQL Server 2000 virtual server installed fine on the present node but was unab...more >>

I have a single SQL 2000 Enterprise server and I need to turn it into a cluster. We have several applications using SQL, so the hostname and configuration of the cluster must be the same as the existing single server. The operating system is WS2003E and they are in a AD domain. Is there a f...more >>

Are there any reported issues with MDAC 2.8 on a SQL Server 2k SP3a? Can you point me to some articles that discuss SQL Server 2k cluster or just SQL Server 2k and MDAC 2.8? Thanks,...more >>

Good day, I'm looking for a document that shows the steps needed in order to install SQL 2000 on a windows 2003 cluster. Thanks in advance Oren Zippori ...more >>

Hello. We have a SQL Server 2000 Cluster on Windows Server 2003 that is running great. We had a network outage last week, however, and the whole cluster went down. We noticed that the Cluster Group "IP Address" resource went down and that then took the SQL Server services offline. We ...more >>

Dear All, I have an SQL CLuster Setup on Windows 2000 Advanced Servers on 2 nodes connected to SAN Storage using Fibre Channel adapters. Every week i have an unexpected restart on either of the servers. I am enclosing few of the erros generated in system log of the event viewer on the ...more >>

Hi everyone, A while ago a posted a message about Virtual SQL Server Timeouts. There were some good responses. Eventualy I discovered that the problem was due to SQL Server being unable to grow the Transaction Log automatically after the Transaction Log gets very large(over 30 GB). I had disab...more >>

I have a w2k3 cluster w/ sql 2k failover. Problem: the SQL fails over OK, but not the IP Addr Any Ideas?...more >>

I have a w2k3 cluster w/ SQL 2k failover cluster. Problem: when I fail the cluster to the other node, I can access the SQL name but not the IP Addr. I need it to work so I can rebuild the primary node. Thanks! ...more >>

Everything worked fine, but days ago my node1 stopped and stoped few times per day, this is the event log.... Event Type: Error Event Source: MSSQL$SQL1 Event Category: (2) Event ID: 17052 Date: 11/5/2004 Time: 10:15:16 AM User: SQLCLUSTER\sqlsvc Computer: CLR-SQL1 Description: Err...more >>

Hi, i have to node cluster on w2k3 when i check the servername parameter i see the virtual server name but i want to see the real address on dns name for each machine . is that possible ? i want to write a store procedure to help see on which machine the sql is currently runing . ...more >>

Hi, When the primary server fails and the secondary starts to take over the job, what will happen to the transactions opened on the primary node prior to failure? Thanks, Leila ...more >>

Hi, While installing SQL Server on the primary node, it needs an IP address for Virtual SQL Server. Should I enter the IP address of the primary node machine in the network or something else? What's the advantage of adding more than one IP in this screen? Any help would be greatly appreciated. ...more >>

I have read from the MS SQL Server 2000 High Availability book by Allan Hirt that Renaming a SQL Server 2000 virtual server is neither possible or supported. What is a workaround to this procedure if you would like to move your present virtual server to a new server? The database is 300 GB...more >>