If tempdb is always recreated (from model) on failover, what reason is there to put it on a clustered drive? If it is put on a drive (letter) that exists on all nodes (e.g., C:) it should work, shouldn't it?...more >>

What are the steps necessary to set up replication for servers across domains where there is a trust relationship? How does one server see the other server? It doesn't see it when you try to register servers. -- Posted via http://dbforums.com...more >>

When a failover occurs, is tempdb destroyed and recreated or is it retained intact?...more >>

Need help to understand why SQL Server Agent fails after installation of MDAC 2.6 SP1 in a SQL 7.0 Cluster. All microsoft docs donot explain the specific reasons of the failure. Can anyone help with the specifics? why or what is failing, and why there is no easier recovery? Thanks, ...more >>

I am trying to understand the type of events which are available to configure within SQL 2000 (S2K). On the surface this implementation is more of a hardware & OS type of protection with a little network option thrown in for good measure (all are needed). What appears to be missing are some ...more >>

I have set up the DC on the local network and SQL1 & SQL2. SQL1 has three network cards, local is addressed 10.0.0.20 storage is addressed 172.16.0.1 in a seperate hub/switch and heartbeat at 192.168.0.1 in another hub/switch. SQL2 is configured in the same networks Next Question, to ...more >>

Hi, I've just set up a server with Windows Server 2003 Web Edition and am trying to install SQL Server 2000 Developer Edition. The CD automatically opens and you can navigate throught the menu, but then nothing happens and the install ends there. The PC doesn't hang, but nothing else h...more >>

I have a SQL 2000 Cluster SP3. I had an issue the other night where the SQL server hung. I didn't failover it just stayed in a hung state. I failed it over manually to the other server and left it there without a problem while I did research on the first server. Going through the error log t...more >>

Hi , I have 2 windows 2000 servers in a cluster environment .I am seeing messages every 5 mins saying another node is unavailable .After 3 or 4 mins the node is available again .I have checked cables , switch etc looks fine . Any advise appreciated . Regards John...more >>

I have a SQL 2k install on a server that will be clustered in the future.... When I add that server as a node in the windows 2000 cluster, can SQL remain *Unclustered* or MUST I cluster SQL as well? -- Wayne Snyder MCDBA, SQL Server MVP Computer Education Services Corp (CESC), Charlotte, NC...more >>

We have heavy inserts and updates on 5-6 tables in the tables more than 10,000 inserts and 20,200 updates and much more selects how often should the tables be indexed to gain optimal performance .. please let me know . i am facing a lot of performance issues with SQ...more >>

Hello, I am running a SQL Server 2000 Cluster on Windows 2000 Advanced Server. Before i upgraded to cluster, only one of the nodes in the cluster had SS2K on it, and after the scale up to the cluster, the old instance still stayed there on the first PC. The cluster runs fine, and does failove...more >>

hi, i have a database on sql server 2000 & winnt as OS. i get a error telling, "suspend Database".Cant able to read or write anything in database. Thanks in advance, Amit...more >>

Hi, Can anyone help regarding this problem. We got this error message and where not able to access the Server. Its an Active/Passive Cluster setup (SQL 2000) Event Type: Error Event Source: MSSQLSERVER Event Category: (3) Event ID: 17052 Date: 8/20/2003 Time: 2:10:00 PM User:...more >>

Hi, I am trying to undestand the difference between clustered index and non clustered index...Please see if some one can help me with following 1)can some one give me case when having non cluster index would be faster than creating a clustered index. i know you can only have one clustered i...more >>

I have two clustered databases environment (4 pc's) on Win 2000 Advance Server OS running an SQL Server7 cluster. I'm trying to create a linked server between the two virtual servers. I've tried through enterprise manager. It creates it successfully, but I can never contact the other se...more >>

Hi ! I've finished setting up my Virtual Cluster Server on Windows 2003 server. My cluster System contains two nodes on Windows 2003, the storage share bus's hardisk is partitioned as Q disk (1Gb-used for Quorum) and P Disk (202GB - used for Cluster Data) with Raid ADG Fault tolerance. An...more >>

Hi I have a plan for 2 node win2k AS /sql 2k clustering. but the databases on both nodes should have same data.is there any way that shared disk gives us the same data?or we must go for replication, then what is the impact of server performance. we are actually planning to go from that nod...more >>

Hi I'm just trying to optimize my sql servers memory configuration. We have an active/active cluster. In node A we have 2 sql instances and in Node B 3 sql instances. Each node have 8GB ram. I don't know how to set memory for best performance. Should I enable AWE? Should I use the /3gb i...more >>

We'll be moving to a clustered situation in the near future and I have some questions: We'll be purchasing new hardware so that's not a huge issue, but any thoughts would be appreciated. In the meantime: 1) 2000 Advanced Server or 2003? Does it make a difference? 2) Is it still tr...more >>

Hi, Is it possible to configure an active-active sql clustering with snapshot replication on one of the database for reporting. How do you setup and where will the distributor, publisher and subsciber be. Pls advice if there is another way of replicating this database for reporting cons...more >>

I am looking to run win2k/sql2k on a two node cluster. I cannot find a clear definition of what an active/active cluster consists of. For example I want to run multiple instances of sql server. Each instance will have it's own disk resources but will only reside on one of the nodes. Is...more >>

Hi; I am trying to install SQL Server 2000 in a clustered Windows 2003 environment. The installation went all the way to the end on Node 1 and then a message poped up indicating a failure. In trying to install it on Node 2 or install on Node 1 again I get an error indicating a previou...more >>

All, Trying to install SQL clustering, I get the generic message that the setup failed, with the -1 in the setup logs. I noticed that when i kick off the setup that the clustered servers cant communicate with one another. they cant ping one another, but when the setup isnt running, commu...more >>

I am having trouble viewing SQL counters in my SQL2000 SP3 cluster. I have followed various documents on re- installing the counters and these work until the cluster is reset. I would like to try a registry rebuild in case anything has become corrupt however when I run the sql setup program...more >>

hi, is there any need to apply patches for blaster virus on sql server cluster servers running with win2k sp3 and sql sp3 with replication . if yes is there any special procedure to do this. Thanks Biju ...more >>

We definitely have a need for high availability, but what I've been hearing is that clustering SQL Server doesn't actually translate to any real gains in the real world and, in fact, unnecessarily adds to complexity. I'm wondering what those with actual experience think. Is this an approach...more >>

I installed Veritas backup exec version 9 on one 1/2 of my cluster. This installed mdac 2.7, which i have found out after many hours with veritas that sql7 on a cluster should not have anything over and including mdac 2.6. Now my sql services are hung, and to boot i cannot uninstall Backu...more >>

All, We have two servers with win2k3 enterprise, all setup with clustering We are using sql2k enterprise, and have purchased licenses for 4 processors I start the Sql2k3 install, go through all the prompts, then the install fails at the end with: "Setup failed to perform required operati...more >>

I have a Single node SQL Server cluster running. I would like to add another node to this cluster to make it a two node cluster. I want to make it Active/Passive. 1) Are there any precautions that I need to take to add a new node? 2) Do I have to install SQL Server on this second node als...more >>

Thank you for your advise.=20 I have one another question...Is it possible to install=20 MS Exchange ONLY on the second node without configuring=20 failover for this application? I=B4d like to configure=20 failover only for MS SQL Server and run MS Exchange on=20 the passive node - as a single ...more >>

Hi Friends, I have configured Cluster SQL server with 2 nodes. Everything is working fine on SQL side. But I am not able to connect with my sqlcluster server fron IIS aplication with are loaded to other IIS server. This is my topology: 2 IIS servers with load balacing 2 SQL servers and 1 SQ...more >>

Hello. I am getting troubles with installing sp3 into my cluster. Its works under Windows 2000 Advanced Server and MS SQL Server 2000 EE, cluster works in Active/Passive mode. SP3 Setup returning me message that "Setup Failed to Perform Required Operations on the Cluster Nodes". I already trie...more >>

I am preparing to install SP3a on a cluster environment. This is an ACTIVE/ACTIVE cluster with two SQL instances installed, one on each node. Node1 has an instance called VRSQL1 and Node2 has VRSQL2. After reading the MS Q811168 article it says that after performing the SP3a install the setup ...more >>

Hi! can anyone help me with ms exchange installation on Win2000 active/passive failover cluster? There will be 2 nodes (identical servers) with W2K Advanced Server and SQL Server Ent.Edit. 2000, MS exchange should be on the "passive" machine. Is this correct? I mean placing exchange on ...more >>

We are trying to implement a Microsoft Cluster Server with SQL Server 2000 for a High Availability trading system. The servers that we are looking at to purchase are two HP DL760 G2 with 8 processors (2.0 GHz) and 8 GB of RAM. We set up the Microsoft Cluster Server on the two Windows 200...more >>

I've received the following answer from Microsoft people: Active/active. In the active/active configuration, all servers in the cluster regularly process information, but one or more take on the workload of a failed server. I'm still not sure - can I use an external common shared disk array,...more >>

Can sql server standard edition be setup in cluster mode?...more >>

Can one setup a Failover Cluster with SQL Standard edition? Thanks, Tim Schmitt...more >>

does anyone know if it is possible to to have a cluster that is active and a cluster that is passive. here is why i ask: we are looking into merging two SQL dbs into one. We will have two servers that will be clustered w/2003 ent. which will house the single merged db. We would like both t...more >>

I am trying to install SQL 2000 onto a Windows 2003 2 node active/active cluster. During the install on the first (primary) node it gets to the point were 'Setup is creating Virtual Server resources on the cluster.' and then times out and fails the install. In the event log I recieve the fo...more >>

I have a two-node Win2k/SQL 2k cluster. We got rid of active directory due to requirements. Have been running the cluster with local accounts for about a month or so. Having permission problems installing latest hotfix (03- 031). Are non-acitve directory clusters supported? Is there ...more >>

We want to replace the current 100 mbit card with a gigabit card. Internally the 100 mbit card has been named "Public". The SQL Server IP/Virtual server is exposed on this network card. Is there an easy way to simply replace a network card? (been looking on MS site for instructions, but haven'...more >>

What is the best way to carve this MSA1000 shared disk? Disk-to-Controller Layout for MSA1000 DriveBay SCSI ID Port 1 0 0 2 1 0 3 2 0 4 3 0 5 4 0 6 5 0 7 8 0 8 0 1 9 1 1 10 2 1 11 3 1 12 4 1 13 5 1 14 8 1 They are 10,000 RMP 72 GB Drives. Here i...more >>

We have 2 Dell 8450's in a cluster configuration. They attach to a SAN. These servers used to run WinNT 4 and SQL 7. Six months ago we upgraded to Windows Advance server and Sql 2000. Everything was fine until the Primary Node failed. We had to rebuild the Primary node. Now we are having ...more >>

Hello, This is a follow up to a cluster design question I posted last week, Geoff if you are still out there your input would be appreciated. We are thinking about running 3 databases on a single Active/Passive cluster and a point of concern is our evening maintenance and backup jobs that...more >>

Hi! Can anyone help me with some advice? We have a unisys based sql server 10 terabytes large that has 4 partitions. It is currently active/passive. The problem is that there is no test environment. We don't really want to go active/active unless we really need to. The server has alr...more >>