I am doing an SQL Server 2005 Cluster install. The install appeared to go okay. On the active node everything installed fine. However, when we looked at the other node only the configuration tools got installed. SQL Server Management Studio did not get installed. Would anyone know what caused ...more >>

Hi All, I am have installed a single-node sql server 200 cluster on windows 2003 (SP1). The SQL Server resource is not starting if MSDTC is configured as a cluster resource. The SQL Server resource is starting if MSDTC is not configured as cluster resource. Regards Balaji...more >>

How do we figure out Primary and Secondary Node for a active-passive clustering setup on SQL server 2000. Are there any simple and straight commands to find them?...more >>

Hi Guys, I am planning to upgrade my sql 2000 32 bit to sql 2005 on new cluster hardware. shall i go for 32 bit or 64 bit ? my application is a critical OLTP application with DB size around 10 gb and i hve application written using visual studio.net,VB 6.0 ,ASP and other sql servers 2000 3...more >>

Well - first TIA! We have an Active/Passive cluster running W2K3 Enterprise X64 Sp1, 32GB RAM and SQL Server 2005. We're moving to a N+1 configuration (and then maybe N+M later), but I'm running into an error. After I cluster the third server and try adding the failover node (it's the sa...more >>

What are cons for placing both stage and production versions of the same db on our only "real" cluster? 4 cpu / 4 gig ram dell server. We have heavy batch work where we prepare data for submission to another process, so there is a ton of munge work in the batches for 2+ hr durations and th...more >>

I have a cluster A/P 4 processor 4 gig of ram with 3 gig allocated to SQL server. I have put on the same cluster my testing of 2005 and will switch over soon. How does SQL Server deal with RAM between the 2 instances? TIA __Stephen ...more >>

Hi, We have a 2 node active \passive windows 2003 cluster hosting SQL and a virtuals SQL server isntance. We need to perform maintenance on the SAN (24 hours outage), but need to still keep SQL accessible. Is there anyway to move data from SAN disk to local drive of one node and not los...more >>

I currently am running a Windows 2003 64 bit server with SQL Server 2000 service pack 4 with the following hotfix http://support.microsoft.com/default.aspx?kbid=899761. I am trying to enable the AWE support to take advantage of my 8 gigs of memory. I have currently ran the sp_configure 'awe en...more >>

I need to move SQL 2000 databases from existing stand-alone servers to an already established SQL 2000 Cluster. What is the best way to do this without losing permissions, jobs, stored procedures, etc? The drive letters in which SQL is installed will likely be different as their are multiple...more >>

Dear ALL, I am running sql 2000 (sp3 a) on a cluster (comopaq) with database located in a raid 10 array . it was woking properly since 2002 but recently i getting lot of index corruption around 5 corruptions in this month and all rectified by recreating the corrupted indexes . but it is happ...more >>

Hi. My application is based on ASP.NET 2.0 and SQL Server 2005. Most of my data-processing happen on the SQL Server (in two stored procedures written in C#) - the webserver don't do much in this setup. I'm investigating ways to have load balancing of the data-processing accross multiple (ph...more >>

Hi experts, I'm running replication from SQL Server 2000 to Sybase. Whenever I do a failover from one node to the other I get duplicate rows. That means that certain transactions are done twice. What can I do to avoid that? Thanks a million, Avi ...more >>

We have a 2 node windows 2003 enterprise edition cluster (S01 and S02). -2 sql servers running in 2 different virtual servers (V01 and V02). -The V01 SQL Server's preferred node is S01 and the V02 SQL Server's preferred node is S02. -On V01 one database has fulltext catalogs. -When the V01 v...more >>

Hello, Need help. Have 2005 SQL Server cluster... I need to change the service accounts for SQL Server, SQL Server Agent, etc to a non-administrator domain user. What is the correct way to do this? From which node do I change the service accounts? Do I need to change them on both nodes? ...more >>

Hi, I have setup a 2 node clustering (Active/Active) of SQL Server 2005 (IA64) on windows server 2003 (IA64) ..Now i am planning to add Analysis Services on this cluster. My question is if i have to add the analysis services as a cluster aware application, do i need to have another IP addr...more >>

I'd like to find a program that clearly demonstrates how SQL 2005 failover works (flawlessly). This application would be used to show that a failure can occur and users are not impacted by that failure. This program would: 1) execute a datareader to page through a query displaying its da...more >>

Hi, I am newbie to SQL Server and Clustering as such. I would like to perform a SQL Server install over a cluster. For this will a machine having Win 2k Professional and 2 * 100 GB hard disks suffice? Will the Cluster service be available with Win 2k prof? Also, can any one point me to...more >>

Hi, SQL Server Fulltext resource is deleted from resource group when i add back the SQL Server Fulltext resource its not coming online any pointers? Thanks, Sree...more >>

Hi, I have 2 SQL 2000 Ent. instance, one is stand alone (test) and the other instance is on Cluster (production) (W2K3). I have an application perfomance issue, the application runs ok on test but it is slow on production. I took a network capture for both instances and anlyzed the commu...more >>

We need to move our existing SQL 2000 data to a new SAN. If I move/copy the database files to the new SAN but remap to the same drive letter, do I need to perform a detach/attach of the databases? Assume the databases will be offline. The cluster node running SQL will remain untouched apart ...more >>

Hello, I had to change domain administrator password. SQL 2000 on WIN 2003 cluster is running on domain administrator account. After i changed password i cannot get into Enterprise Manager with windows autentication. I did not restart sql server or cluster, just changed the password for SQL a...more >>

Can SQL be virtualized and then clustered on separate host servers? Or do the virutal servers have to exist on the same host? What I am asking is can virutal servers be clustered on separate hardware? Thank you in advance....more >>

Hi, we are palnning to aquire new Cluster hardware for sql 2005 on win dows 2003. database size 10 gb.active/passive cluster. pls advice best suited hardware model what about DL 380 G5 WITH MAS 1000? note: Price is not a constraint. rgds Biju...more >>

When we try to install SQL 2005 on a two node cluster with iSCSI NetApp-Storage (Cluster is up and running), setup fails with the following error message: "The drive specified cannot be used for program location. Program files must be installed on a valid local disk available on all cluster...more >>

I had an issue with the SAN drivers for my SQL cluster and although I did not lose any data I lost all the SQL cluster resources (drives, IP addresses etc). Is there a way to repair or reinstall the cluster resources using setup or some other manner? Thanks. ...more >>

Is there a doc describing max number of nodes per sql 2005 version. Is it correct that SQL2005 standard can support 4 nodes cluster Thanks...more >>

How I can install service packs to 1 node only without affect the other node? I remember there is a registry change for that, but can not find it. Thank you!...more >>

Hi all, I failed failover to a secondary node and found that the sql agent was 'disabled' in the secondary node. However, in cluster admin and SQL Server configuration Manager, it shows the SQL Agent is running. Also, there is no error message in event viewer. BTW, I can't found the manag...more >>

I am trying to plan a SQL Server 2005 cluster across multiple data centers around the world. Basically the database backs a load balanced web application. Each site has its own set of web servers and its own database servers but the databases must be in sync around the world so minimal downti...more >>

I have a new a two node cluster (each node with four dual-core processors) on 2003 Enterprise OS that will host a new SQL Server 2005 environment. Four Standard Edition processor licenses were already purchased for the new environment. The cluster was intended to run Active/Passive, but I have...more >>

I had previously read a thread on this newsgroup stating multiple instances were not supported on a single cluster with SQL Server '05 Standard Edition. I'm researching information to take to the business for why we need SQL Server 2005 Enterprise Edition instead of Standard Edition. This is ...more >>

I currently have a Win2000 cluster (2-nodes) with virtual servers\instances SQL1\SQL1 and SQL2\SQL2. What I want to do is move both to a Win2003 cluster (2-nodes). The catch here is that the Win2000 cluster is running on a SAN that does not support Win2003 hosts. I setup the new Win2003 clust...more >>

Hi there, We are facing an issue with the failover cluster of sql server 2000 sp4. It is running on a windows 2003 server with sql server 2000 sp4 and clustered [build 2187] memory 64 GB Error causing sql restart is: ---------------------------------------------------------------------...more >>

Hi, We've got SQL Server 2000 on a W2K3 2-node cluster, however its starting to seem that the shared storage is unreliable/failing. Is there any way to drop the cluster to single node and then shunt the database onto the local storage of that machine? I've found posts indicating it could be...more >>

Hi everybody!. Sorry for my English skill. Can anyone help me how to clustering sql server 2005 in Windows 2003 server? I had tried in Google but I couldn't find any documentation Thanks for all replies...more >>

Hi, Can I install more than one "named instances" on a vitual clustered SQL Server2005? If so, How can I? MaDS ...more >>

Hi, Currently I am confronted with an issue to estimate how should we organize or what should we buy in order to provide high availability and efficient response times. I have 3 different DBs one which have high read activities, one has high Read-write activity and the third one is for Bizta...more >>

Hi All, We are in the process of setting up a DR environment for our core systems. I'm torn between a couple of idea's where I'm not sure where to head, so need some advice... Our Data Centre has 4 x 2 Node Clustered SQL Servers and 4 individual SQL Servers. Our remote site (head office) is...more >>

Hi, I'm new to SQL2005 so if this question is a stupid one please forgive me. I have setup a clustered SQL2005 with a default instance. This is working fine. Now I want to add 3 more instances to my cluster. How can I do this? I can't find a proceudre that talks about this. So I tried so...more >>

Hi there, Here is the situation: Current config: Two nodes clustering multipe instances SQL Server 2000, in Windows Server 2003 Enterprise Edition. SQLA, with 16GB memory, set maximum 9GB memory. SQLB\INS1, with 16GB memory, set maximum 5GB memory. I would like to add another active node...more >>

Team: I have a Cluster server in a SAN with Drive SAN drives attached to the Cluster server, running SQL 2000. I just added another drive volume H:\ as my backup drive to run all my SQL backups to disk. When I added the volume to the cluster and put the disk in the same resource group as my...more >>

We are installing SQL 2005 SP1 on a 2 node single instance windows 2003 cluster. During the install I receive a box stating i have locked files. The file is c:\program files\microsoft sql server\90\shared\svrenumapi.dll(wmiprvse.exe). I have read the KB article that provides a fix for lock...more >>

We have 2 boxes running clustered windows enterprise OS 2003, SQL server 2000 sp4, also clustered. Everything runs fine, except when we do a failover of sql to the other node, full text indexing will not index. The properties come back with an item count of 1. The only "errors" i can find a...more >>

Hello, I'm looking for solution of minimizing downtime(amount of reboots) when installing SP4 on 3-node cluster running 8 SQL2K instances.I anderstood from readme file that after each instance installation boot of all nodes in a cluster required. It poses a problem for us since too long do...more >>

Can anybody provide me with specific hardware and software requirements for Two nodes SQL Server Cluster. Thanks in advance. ...more >>

Hi, We would like to apply SP1 to our Windows 2003 Enterprise Cluster server. The Cluster server is on a SAN with an active/passive setup. The main service running is SQL Server 2000 Enterprise. Is there anything that I need to know from a DBA perspective? -- Paul MCDBA, MCSE...more >>

I would like to find out if there are any free tools that could be used to monitor a sql instance and list the a. most frequently run stored procedures and how long each takes b. most frequently run views and how long each takes netiq used to have app manager - is that still available ? ...more >>

I have set up my A/P cluster, and SQL 2005 sees my data partition of my RAID for the data no problem. How do I get to use my second partition of the RAID for my Log files? Yes I have a third partition for the Quorum. I can restore the db from a USB device that is plugged into the Active n...more >>

Hi there, We have three live production SQL servers and one of them is nearing capacity. I have been asked to investigate SQL replication and there is an understanding that SQL replication is the hold grail and it will solve all of our problems. I have spoke to a few developers within the ...more >>