HI ALL I had a sql server name server1 and that is the name for my SQL name too. I am setting up the cluster server to retire that that sql server. Can I have new sql server name as same as my old sql server with out shutdown the old box? The computer name will be diffrence between old server ...more >>

Hi Looking to build an implementation plan in order to test/refine for migration. Scenario ----------- NT4 Cluster on SAN (BDCs in NT4 domain) File and Print SQL 7.0 Active/Active System Partitions only 1.95Gb! (Partitions need erasing) End Result -------------- Move to alternate W2...more >>

Hi, I have an active / active 2 node cluster running windows 2k and SQL 2k. Both instances will succesfully come online and run concurrently on the first node but when I try to run both instances on the other node the SQL server agent service fails for the second instance. I can take ...more >>

Hi, We have a active/passive SQL cluster which has fiber mode enabled. One day when trying to do something with Sharepoint 2003 the following message appeared: XML stored procedures are not supported in fibers mode Ofcourse this feature is needed so we have disabled fiber mode. Is there a...more >>

Based on our testing of current environment it takes approximately 4 sec to grow the database by 150MB and 2 minute to grow the database file by 3.5GB. Process of database growth will negatively impact performance during periods of high load. It is generally recommended to avoid database...more >>

I have one NT4 cluster with active/active SQL7 on it. I want to upgrade the Windows to W2k orWS03. Eventually the SQL7 will be upgraded to SQL2000 as well. Is it possible to do a rolling upgrade safely, and if so what's the strategy ? I have seen several articles about rolling upgrade...more >>

We have build an active/active cluster with a default sql instance on one server and a new instance on the other. We would like to put the sql transaction logs on a different logical drive than the data files, however when we go to the properties of the database in enterprise manager it d...more >>

Hi all, I am not well-versed with cluster servers, so bear with me, and help me if possible. We have a client who is using our software product. While using our product and trying to load some data, we are getting an error. The error suggests that a DLL is bad (According to MS Kno...more >>

I have installed SQL2000 sp3 on w2K3. When I first tried to connect from a W2K (sp3, MDAC 2.7) web server I received an error MSDTC on "server" is unavailable. I tried to start MSDTC in enterprise manager but nothing happend. I then followed the KB artical 294209: HowTo: Rebuild or mo...more >>

My clients lose their connection to the virtual machine when it rolls over from the primary to the 2ndary server. They need to restart their app to get reconnected. I read an article on technet saying this is normal behavior. Does anyone know a way to keep the clients up when the servers roll ove...more >>

Suppose I have a cluster of four nodes, three nodes out of four are running active instances and the fourth one is passive. Do I need SQL license for all four nodes or just three nodes? Its windows 2003 and SQL 2000 enterprise editions. Many thanks in advance. -Mehul....more >>

Microsoft Office can be installed as a server / Client installation, where most of the processes is being handled by the server. My quistion is then, does MS Office support clustering? Is it possible to make a Load Balance soulution with this kind of Office installation? Or if not, does anyone...more >>

Is there a way to install a SQl2000 cluster next to an exsisting SQL 7.0 cluster environment on windows 2000 advanced servers?...more >>

hi, We set up a log shipping job on our control server for one of our sql servers and its fail-over server. We keep getting these kind of job failures from time to time: 'The job failed. The Job was invoked by Schedule 12 (Log Shipping Alert Job - Restore). The last step to run was ...more >>

Our team had requested that the SQL Server data drives be set up as a RAID 1/0 but the system administrators set up the hard disk with RAID 5 all drives on the SAN except C: and E:. This system is set up with Windows 2000 Advanced Server with Clustering and SQL Server 2000 with Transact...more >>

hello to every body. i have got a cluster system. windows 2000 Advanced Server SP4. In the node A , I am installing the SQL SERVER 2000 ENTERPRISE with SP3. The type of installation is LOCAL COMPUTER. The execute files were save in local hard disk and the DATAS and TEMPs files were sav...more >>

Hi Guys, i am having sql server 2000 fail over cluster but my sql server full text search service is shown as failed in cluster administrator ? all other resources are online. what colud be the reason and what i can do? pls advice me Biju...more >>

I have a SharePoint Portal Server v2 farm deployed accross node servers connected via VPN. This is working out well thus far. I wish to setup failover for the SQL configuration and content databases so that if one node fails, the portal server remains online. I will post to the IIS newsgroups ...more >>

After the Windows 2000 Advanced Clustered Server with SQL Server 2000 was rebooted. Client computers are no longer able to map to the server drives but are able to map to virtual server drives on the server. What has caused this problem? Please help me resolve this issue. Thank You...more >>

I am looking for an article on how to set up Microsoft's Cluster dependencies with examples and guide lines. Thank You, Tim...more >>

It stated that you should use the Windows Clustering Server Cluster APIs to create cluster- aware applications. Looking at some articles on the web it does not appear to be self evident how to use it. Does anyone know of a good example/tutorial? We will try to use it for handling failover tha...more >>

Hi, I think our sql cluster has a memory leak as we are getting this error after the server has been running sometime and the our iis servers lose their connections to the clustered database (active\passive). Does anyone have any ideas of how to resolve this or what to check to diagnose a memo...more >>

Dear Experts, I would like to insert a result set from the SQL server 2000 Stored procedure to Oracle 9i database. I am thinking to create txt file out of result set, but I am not sure How can I create a txt file directly from stored procedure? Anybody has a better Idea? TIA...more >>

I have set up Windows 2000 Clustered Server with SQL Server 2000 to use Named Pipes and TCP/IP protocols. Is it recommended to use both protocols are just TCP/IP? This would be very helpful if you can answer this question and the reason why. Thank You, Stephen ...more >>

During an install of SQL Ent on a two-node cluster, the install just died (Dr. Watson) after inputting the account info that would have access to both nodes of the cluster. The cluster itself works fine and utilizes a user called "cluster" I created to logon to each server to run the clus...more >>

I have a Windows 2000 Clustered Server with SQL Server 2000. The server has 8 GB of RAM. Microsoft recommends creating Pagefiles 1.5 * RAM on the server. I have 8 GB of RAM, so I need to create 12 GB of Pagefiles. My server drives are set up listed below. Drive Size (GB) Pu...more >>

I am trying to move my TEMPDB file on a Clustered SQL Server 2000 for my F: to H: drive. My SQL Statements: DBCC TRACEON(1807) USE Master go ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = '\\TVLDBP01A\H$\csdata\mssql2k\dbfiles\tempdb.mdf') go ALTER DATABASE tempd...more >>

Hi, One of my cluster nodes crashed last night and I had to reinstall it with windows 2000 Advance Server. I have also installed the cluster service and joined the existing cluster with no problems. I can no see both my nodes in the Cluster Administrator Console. On my primary node SQL S...more >>

I'm sure this question must have come up before but I couldn't find a related post doing a search. In SQL 7.0 days there were problems clustering SQL when using hyphens/underscores in the computer names - it was always best to avoid them. With SQL Server 2000 this would appear to be allo...more >>

Hi - Using SQL Server 2000, Enterprise edition I have a broken node (intermittent hardware failure) that needs to be removed from the cluster and rebuilt. Unfortunately I'm struggling to perform the removal. I'm following the BOL instructions "How to remove a node from an existing failo...more >>

I am getting the following error when I try to enlist a configured component in a manual transaction. The error only happens in a cluster so I am posting here rather than a COM+ group. I have a seperate resource group for MS DTC (with resources for IP\network name\DTC). The sequence of actions le...more >>

Running an active/active cluser with each node running a virtual server and one instance of SQL2000. Recently one of the virtual sql servers failed to start the sql server service, now I cannot remove this instance of sql or even add a new virtual server/instance. The error codes that I ...more >>

We got the recommendation, for W2K3, that you should create a separate resource group with an IP Address, net name and disk and then create your DTC resource for that. Would be interesting to get comments and experiences regarding this subject....more >>

Im doing my research and came across a question. In an Active/Passive failover scenario I read that you can do upgrades with little downtime by doing a failover and then upgrading the server and then failing the cluster back and then upgrading the passive server afterwards. If thats the ca...more >>

This is what's happening.. Log shipping is installed and operating normally. The Log Shipping Monitor, which runs on the DR server (separate to the cluster), reports that all 10-minute log backup/copy/restore operations are normal Server1 is taken offline Server2 assumes ownership of all resou...more >>

Hello It's a long story to tell.. since October we are suffering several lost of connectivity with our clustered SQL server That's it.. We had two Unisys machines clustered working well, no connection problems and good performance On 1st november we done an intervention on the Cluster, we pluge...more >>

We are consolidating a number of SQL Server 2000 databases. We will have an environment with failover clustering. Does anyone have experience with MS DTC and BizTalk in such an environment? Things like separate instance, file placement, etc...more >>

Hi guys, i am running my sql server 2000 on win2k with fail over cluster. now i am planning to install anti virus software on all servers including this cluster .will it cause any problem to cluster and what is the recommended approach. pls advice Thanks biju ...more >>

I can't get it to work. I downloaded an article on Windows NET mag website "A VMWare Clustering Recipe", and followed it to the letter. When I try to configure the cluster, I get the message "Cluster service Setup did not find any disks on the shared SCSI bus that meet the criteria for clusteri...more >>

Hello: I want to extend the SQL server volume (SAN disk) as the volume is getting nearly full. Can anyone recommend a procedure that impacts little or nothing? I am trying to do mount volume to a folder. Does it help? How does SQL server know about that folder? Can we assign ...more >>

We are using W2k, SQL2K, clustered, active-active. We have setup a new clustered sql environment. I am migrating databases and wondering what will happen if we create an alias in DNS which has the old virtual sql instance name associated with the new virtual sql instance IP address. The h...more >>

Hello, I have successfully clustered SQL and a file share in an Active/Passive configuration (we could not afford Active/Active licensing). Now I am looking at the administration of the cluster and I have some questions. First off, is it safe to put Symantec AV Corp. edition on the clu...more >>

Hi, I have a Windows Server 2003 cluster setup with 3 SQL Server 2000 virtual servers installed. When I perform a restore of an 85 GB database, the database gets stuck in a 'Database Loading' state. It doesn't appear to be a resource issue since SQL has access to all 8 processors and 4...more >>

I recently expanded my external raid array with intention to move the SQL log files to a newly added drive partition. The cluster nodes are both running NT4. The drives are picked up by Disk Administrator in NT4, but when I try to create a new physical disk resource for the cluster, the ne...more >>

It has come to my team's attention that our current 2- node, SQL cluster does not have enough shared disk space to house future growth of the databases it currently houses. We have no issue spending the $$ to buy additional drives, but what are steps necessary to reconfigure the RAID array...more >>

Dear Friends, First of all, I want to make clear that it in not my intention to use clustering. I have all my database files in a shared storage and a pair of SQL Servers pointing to each of them. In other words, I have two identical servers looking at the same databases. As a side note, I ...more >>

Hello, We are in the process of migrating multiple stand alone Win2k-SQL 2k databases to a 2 node active/passive cluster with SQL 2k and a Fibre SAN device for the logs and data. We are planning a phased approach where the first phase calls for a single Win2k Adv node with SQL 2k standard edition c...more >>

Hi I am attempting to become a MCDBA. I want to learn and experiment as much as I can with SQL- Server 2000 on my home computer. I have a powerfull home computer but I is not a full server (ie multidisk, RAID configured etc). Because this is for my own training - all issues important ...more >>

We are planning building a cluster in a new production environment. Due to budget/size needs the shared disk space will be an external array (not a SAN.) The current plan is for an array with 8 36GB drives. We are tentatively planning to use Windows 2003 as the OS. I read something that s...more >>

Does anyone know any good books I could pick up that would help with the installation process of SQL server 2000 into a clustered environment?...more >>