I have an Win2000 Active/Active Cluster running SQL 2000. Each side of the cluster is running its own named instance of SQL 2000 Enterprise. Side A has two physical disks F:\ and G:\, Side B has H:\ and I:\. physical disks. The I:\ drive has enough space to house another instance. The clus...more >>

I have a 2 node cluster with 3 instances of SQL. One specific instance, when I attemtp to take it offline produces the following error: In cluster administrator is shows the SQL Server Resource as Failed Event Viewer produces the following: Source:ClusSvc Event ID: 1117 Description: Clus...more >>

Cenario: ========================================================= Server: Clustered Windows 2000 Advanced Server SP4 DB : MSSQL Server Enterprise Edition, SP 3, version 8.0.0.760 Instaled services: MSSearch, SQL Server, Agent, T-Transaction - All services instaled, and online in cluster mana...more >>

We have a 2 node windows 2000 active/active cluster running with 3 instances of SQL 2000. I have set the memory up for each as follows: Sp_configure 'show advanced options',1 RECONFIGURE GO Sp_configure 'awe enabled',1 RECONFIGURE GO Sp_configure 'min server memory'...more >>

Hi All, We have active/active Cluster setting on Microsoft Windows 2003 DataCenter Server. Installed SQL Server 2000 with SP3, used AWE to configured max server memory to 3072(MB) and the 3 GB switch in the Boot.ini file. From SQL Server Properties, it selected Use a fixed memory size...more >>

I am trying to upgrade an SQL2K instance to SP3a on a Windows W2K3 cluster .... without success. I am able to sucessfully navigate through the various setup screens (using the setup.bat installation), that select my virtual SQL instance, sa username and password. However after I select OK...more >>

Dear Friends, This is new environment to me. Therefore, I would appreciate your comments and suggestions. This is the scenario. I have two SQL servers 2000 (standard edition) connected to a shared storage. I moved all the database files to the shared drive. To my surprise, I noticed that...more >>

Hi, I am trying to run replication on SQL 2000. Replication was running fine on the SQL cluster. Ever since I added 8 to 9 tables in the replication it started giving me some problem. I removed those tables but still it didnt help. I disabled the replication and created again but while ...more >>

Hi, I am running SQL 2000 server. How can I check which serice pack is installed on this server for SQL. I am new to SQL so please help Regards Ripul...more >>

Hi, I'm trying to install a SQL2k Server on a W2k3 based cluster fails. Following the instructions of the article 815431, Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails, I can't resolve my problem. I receive the "Setup failed to perform ...more >>

Hi, I'm trying to install a SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails. Finally, I follow the step shown at the article 815431 where you can find how to install a named instance of SQL2k in a W2k3 cluster. But it's imposible to use the same virtual server name and inst...more >>

Background: I have inherited a new SQL infrastructure based on a 2 node SQL Server 2000 cluster and an HP StorageWorks Modular SAN Array 1000. The SAN was configured with (14) 36GB drives arranged in 2 arrays. The first array is attached is 12 disks arranged in a RAID 5 config. The las...more >>

Hello, I have read through many messages with similar subjects to this one I'm posting, but I haven't been able to find any solutions that work for my problem. I have a Windows 2000 SP3 Cluster running on a Compaq Proliant CL380 with SQL Server 7.0 installed. I've just recently "inherited"...more >>

Hello, We are setting up a 2 server active/passive SQL 2000 and Windows 2000 Adv cluster, each server has 2 GB of memory. Currently we have 2 databases with a third on the way. The databases should be 20GB or less with decent read/write activity. My question is, should we run a separate instance ...more >>

We are in the process of setting up our first SQL 2000 cluster on Win2k Adv server with a Dell EMC fibre san device. My question is regarding the cluster configuration. We are doing this in a 2 phase approach. Phase 1 will be the SAN device and 1 of the 2 sql nodes for Active/Passive. I would like t...more >>

I need to move my clustered SQL server from one domain to a new domain within our AD test environment. I have not been able to find a white paper or much of anything relating to Windows2000 (not Windows NT 4) and moving a clustered SQL server from one domain to another. Any suggestion...more >>

We have a situation, A sql server 2000 cluster on win 2k we inherited with virtual sql server service accounts running on a domain cluster service account. The problem is we recently tried to apply SQL SP3 and the setup ask for the cluster account password which no one has, we thought we coul...more >>

Any service pack upgrade to the SQL server cluster will halt the SQL resource group on the participating nodes. This is not acceptable for today's need for five nines. We should minimize the impact on availability due to patches. For example, if there is just code updates (where code can r...more >>

Hello! I have problem to install SQL Server Ent Ed. on a Windows 2003 Ent. ed. cluster. The setup is creating all the resources in the cluster but when it try to start the sql-server service it fails. Then the setup start a cleanup procedure to restore the cluster in the way it was bef...more >>

Hello all, Excuse me fore some language failures (i'm from the Netherlands). I have a generic question about MSCS Windows 2000. I installed MSCS on both nodes, and try to run some test before production time. --- Test: --- - Boot node 1, who then ones all resources. - Boot node ...more >>

Is Act-Act SQL certified on Windows2003? I cannot get the 2nd instance to install. I keep getting the following event errors: THE EVENTVIEWER APP log Event ID 17052 Source: MSSQL$VSQL02 unidl7401 The description for Event ID ( 17052 ) in Source ( MSSQL$VSQL02 ) cannot be found. The loca...more >>

Is there a guideline on how this can be best accomplished? A how-to perhaps?...more >>

Hi, I need know if there is something special to do for install Analysis Services on a SQL Server 2k that is running on a Cluster environment. Thank you. ...more >>

We ant to run multiple instances of SQL in active active clusters - two to three nodes (on Windows 2003 Ent Edition). Any related documents / guidelines mainly focusing on capacity plnning?...more >>

Full text catalogues failed after installing SP3 on fail over cluster .. I tried the work around suggested in KB;817301 article and still getting the same problem. http://support.microsoft.com/default.aspx?scid=kb;en- us;817301 Any help in resolving the issue or pointing to the right ...more >>

I have a routine that uses xp_readmail to read one mail at a time form an outlook mailbox profile and then process' the saved files. The process has to be 'broken' for sensible error handling. The process works fine on a non clustered machine as it writes to "c:\documents~1\temp\newfilename....more >>

I'd like to setup sql server2000 cluster on my computer for training purposes. I heard that this can be accomplished using vmware software without need to buy any cluster hardware. With it , you can create multiple virtual servers on one computer. Has anybody setup sql server cluster this ...more >>

I have some problem with my cluster server, SQL IP goes down from time to time. Also the mssqlserver service failed to start because of some error. Do I have to re- cluster my server. I found out also that there is some problem with the registry cause I issue -resetquorumlog parameters to b...more >>

Hello, We have a SQL2000 2-node cluster on Win2003. Each server has 2 NIC's, but currently only 1 is active on each box. Everything worked great until we teamed the NICS, at which point Cluster Administrator would no longer connect to either node. However, the teaming itself seemed to be co...more >>

Hi I was trying to create a second instance in my new sql cluster. W2K sp3, SQL 2000 Enterprise no SPs yet. The option to create another instance is grayed out......more >>

Hi, I have 3 set of sql server 2000 in 3 different subnet domain. One is used as data source and it is a single node server. The other two are set up as cluster servers. Since they are not in the same domain, could you please tell me how I can connect to the cluster servers from my data ...more >>

Is SQL Litespeed faster/slower than SQL Native backup ? Is it more CPU/Mem intense than SQL Native backup ? Can a SQL Litespeed backup be restored using SQL native restore and vice versa ? Using SQL 2000 and may wish to buy/try the latest SQL Litespeed Any cons using Litespeed that one ne...more >>

Windows 2000 AS sp4 SQL Server 2000 EE sp3+ My client is testing an application that requires us to change the date on the staging database server. The database server is a virtual server on a cluster. Therefore, I would have to change the date on the node that owns the virtual server. Does...more >>

I have an active/passive database cluster that's overloaded, with nowhere to offload the excess to. Are there reasons for not going to an active/active cluster? Any big gotcha's? I seem to remember hearing (some time back) that active/active was not a good idea, or at lease not recomm...more >>

Is it possible to disable Named Pipes protocol via Server Network Utility? I noticed that ability to disable Named Pipes is grayed out on some of my SQL clusters but not on others. I'm guessing this has to do with SQL SP3a disabling this option. Are there reasons not to disable Name Pipes...more >>

Hi Is there any way to get a totally seamless transition to a fail over server? At the moment, if the primary node goes down then the standby node picks this up within about 10 seconds...which is fine. But, if I'm editing a table during the fail-over then it freezes my connection and does...more >>

G'day I have a couple of questions I am hoping someone can help me with 1) From the SQL Server point of view, are there any additional considerations when deploying a stretched cluster, rather then a normal cluster? 2) Are there any SQL Server components that work on a normal clust...more >>

2 node windows 2000/SQL 2000 cluster 1 default instance and 2 virtual servers default instance is set to use AWE, and min and max memory of 4096 2 virtual servers are set to use AWE, and min and max memory of 2096 When the default instance loads it consumes 4096 MB of RAM immediately, I s...more >>

I have a 2 node Windows2000/SQL2000 cluster residing on a Windows NT 4.0 Domain. I need to upgrade the domain server and am concerned about the status of the cluster once I upgrade. If anyone has any experience with this or could point me in the right direction it would be greatly apprecia...more >>

Listed below are the IP Address that correspond to my Cluster. Should the DSN server be set up so that Virtual SQL Server names are assigned an IP Address. Names IP Addresses 1. BVLDBP01A (Public) 198.159.209.67 2. BVLDBP01A (Private) 10.10.10.1 3. BVLDBPVS01...more >>

Hi, i have a soft that works using MSDE as db engine. My soft have a server version and a client version, but they use a local copy of the database. One generic client sends once a day all his new records.. and downloads the new records from the server.. (other records may come from the server.....more >>

Hi, What are the disadvantages with Primary Key. Is all tables required to have P.K. Thanks ...more >>

Hi Two-parter question if I may: I have inherited a web-based database application. This application is effectively sold to our customers but hosted on our own machine. Each customer has their own copy of the SQL Server 2000 database. One thing we used to do was real-time replication be...more >>

Two questions: 1. Has anyone used MS's database hammer tool that comes with the resource kit? I'm running into errors when running the loadmaster app Any info on your real life experience would be greatly appreciated. 2. Has anyone have real world experience setting up a geographically ...more >>

Hi All, I want to know, Does MSDE support database cluster? Is anybody has done this? Any information about this will be highly appreciated. Regards, Rajesh...more >>

Hi Friends, On the SQL Server cluster we need bak and restore. For this I have a question - When the i m taking a backuo on a server and server failover to another server and backup is not complete. What will happen to the Backup it will be completed by the next Server or it will fail...more >>

The clustered index stores the data pages at the leaf level. What will it store at root and intermedaite levels. Storing data pages at leaf level means, will it store the entire data row or only cluster key columns....more >>

Hello, I have two arrays setup on an external drive array. I have already setup MSCS and it has put these two arrays into seperate groups, lts call group1 and group2. I want to install SQL and use group1 for the SQL data and group2 for the SQL Transaction Logs. Is this possibe? How would...more >>

I recently started this position and one of my first tasks was to create a cluster for a SQL database. The existing DB is on a single server, with replication to several backup servers. I've built the cluster and and am getting ready to install SQL. My question: What is the best approach to movi...more >>

Due to a recent increase in spam sent to posters in newsgroups, Microsoft advises that newsgroup participants should consider avoiding posting to newsgroups using their real email address. Microsoft is also committed to continuing to address the issue of spam from a technological perspective. ...more >>