How load balancing feature is enabled with SQL 2000 clustering service. ...more >>

¸÷λºÃ£º ÎÒÔÚÒѾ­¼¯ÈºµÄ·þÎñÆ÷ÉÏʹÓÃASPÒ³ÃæÖеÄÊÂÎñTRANSACTIONÓöµ½ÁËÎÊÌ⣬ÌáʾÎÒ MSDTC²»¿ÉÓã¬ÎÒÏëÇë½Ì¸÷룬ÊÇʲôԭÒò£¬ÒªÈçºÎ½â¾ö£¿¶àл£¡ ...more >>

Hi - we would like to perform a test sql cluster setup (on two machines) and don't have an external drive array. We do have a some compatible servers and plenty of disk space. What is the cheapest solution for our test? We don't really care much about performance, just want to get some practic...more >>

Hi, I got a problem with a cluster with SQL 2000 EE. Had two servers, Win 2k Adv Ed., one of them died. Failover to node 2 worked fine. Bought some new hardware, installed Win 2k Adv. Ed., SP4, MSCS. I EVICTED the old server form the MSCS console from node 2. I did install the new...more >>

Hello, How do I set the SQL Server Agent and Fulltext Services to Autostart within our SQL Server 2000/Windows 2003 EE Server environment? In non-clustered SQL Server, I just set the services to startup "Automatic" within the Windows Services screen, but I doubt that this is the correct plac...more >>

I have 2 SQl servers one End1 and the other END2. SQL 2000 EE is being installed on ENDSQL1 after entering the the VIP it prompts for the location of the data on the shared array. I am selecting my F: drive which has 40 GB allocated(I can write to this drive, so the drive is configure correctly) o...more >>

The resource [SQL Server] fails to come online. The server is W2003 Enterprise SQL is 2000 Ent. After the cluster is up and running I installed SQL server as virtual and the installation finished with: An error occurred while creating virtual server resources for clustering. The system canno...more >>

For 3 years I had a Windows 2000 server farm consisting of 4 servers (2 web servers load balanced and 2 sql servers for clustering). The 4 servers are in domain. They are the only servers in that domain. I had a hard disk crash on 1 SQL server recently, so I decided to try reinstalling it with...more >>

I have done the setup of SQL Virtual server Cluster setup with one named instance with database and log file locations on the same drive over shared storage f:\. Now I have added new drives in my shared storage box and created a drive g:\ which is accessible in windows Explorer. Now I want ...more >>

Hi GUYS, i can see these errors in sql error logs . are they serious? what action should be taken. pls advice me . SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447 Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'. Stack Signature for t...more >>

I got two hard disks (36GB each) on each of two SQL Servers and one Storage Area Network (SAN) as 73GB x 8. We would like to install SQL Cluster in Active / Active mode Here is my current proposed configuration. Can someone please provide a better configuration if possible The two hard disk in b...more >>

Hi All I'm struggling to find some good documentation on how to place SQL ersources in the cluster groups. Wuold I be correct in saying the following: 1) Place the Quorum and MS-DTC resources in a cluster group together. 2) Place all other SQL and Windows resources in another cluster group...more >>

OK, after several trial installations and reading many white papers and newsgroup posts, I have become completely confused on the proper use of Default vs. Named Instances vs. Virtual Servers. I am looking for the CORRECT METHOD to implement. This is what we have: [2] server nodes, QA...more >>

I have a two node Active/Passive SQL cluster. I need to know how I can bind two IP addresses to the SAME vitual SQL cluster name. I need to add my vitual SQL instance to a Backup network on a private network segment. To achieve this I have added two other network cards to each hosts with...more >>

How do I move a database from a non-clustered sql server to a clustered sql server and be able to use the database....more >>

At our center we were under the impression that with a sql cluster system the app would be up if a node failed and rolled to second node. My question is specifically if in this environment should the client die and have to be restarted. We had the mind set that the user would not see any issues...more >>

Hi I'm using SQL 2000 Enterprise Edition with 2 Windows 2000 Advanced Server nodes (active/ passive cluster) with shared disks We are having some performance problems. The "Boost SQL Server priority on Windows" switch in the processor tab of the properties of the server is off. Does anyone know ...more >>

hi we have a 2 node cluster everything is working fine except for backup maintainance plan backup fails randomly for user database with error 3041 : BACKUP failed to complete the command BACKUP DATABASE [DBName] TO DISK = N'e:\Backup\Dbname\DBNAME_db_200401121800.BAK' WITH INIT ,...more >>

I need to be able to detect (during the installation of my application) if a machine that is part of a cluster is running version 7 of SQL server. Can I do this by reading the registry? If so, what registry entries am I looking for TIA jam...more >>

How do I display the Windows 2000 Advanced Server Cluster logs? Where are the cluster installations logs stored? Thank You, Fred ...more >>

There is a large amount of debate going on in our IT group about whether to go with Active/Active or Active/Passive. We are running several databases using SQL 7.0 std edition. The server has 4 cpus and can only address 2gigs (due to the std. edition). We are getting a pair of new servers with...more >>

I had initial had one server and set up the Windows 2000 server cluster (A) with SQL Server 2000. After several months I received the other Windows 2000 server (B). I set up the dependencies on server (A/B) to match the other Windows 2000 Server Cluster that works fine. When I trying ...more >>

Hello, Wondering if anyone can assist with this problem. We have SQL 2000 clustered over two servers. SQL runs fine when on server 01, but when we try to fail-over SQL to server 02, the MSSQLServer logs the following errors to the NT event log. All have MSSQLSERVER as the source, and all ...more >>

Hi, I have a set of 4 servers coming in to be installed as a cluster running Win 2003 Enterprise with SQL2000, all to be connected through Fibre Channel to a SAN. I am trying to figure out how many instances to install in this cluster. I want to utilise all nodes, so there will be at lea...more >>

I need to add MSDTC service to an already running Windows 2000 ADV server cluster (SP4) w/dual instances of SQL server installed. There are 3 disk groups: Cluster group, Transaction and Data Warehouse. I want to add the MSDTC service to the disk group called Transaction. Per Q article 290624, ...more >>

Does anyone know how to reset or resync the Log Shipping Transaction on the Standby Server? I am in testing mode and ran a backup log dbname with truncate_only and it caused my log shipping mechanism to fail and now I need to know how to resync the process without having to Re-implement the...more >>

Hi. I want to setup a federated database servers for a production environment. What i already have are 4X dual cpu machines (each machine equipped 4 GB memory and 200 GB (RAID5) storage). The operating systems is Windows 2003 Standard Edition and database is SQL Server 2000 Enterprise editi...more >>

I am trying to install a cluster of two computers. Both of them are going to be production machines which have similar applications installed on it. Both have SQL installed and are database servers. As data comes into one of them the SQL on this first machine replicates the data for every ...more >>

Hi all, I've recently upgraded (complete OS and SQL rebuild) a SQL 7 active/active cluster to a Windows 2000 muliple instance cluster. Everything is fine apart from the fact that i get an error message when creating a linked server from another SQL 7 server to one of the nodes in the SQL 2000...more >>

I have a SQL 2000 SP3 virtual database sitting on a pair of W2K Adv Servers SP3. One of the disks failed that held the master database. I ran the Rebuildm utility as per KB-298568 and the LDF and NDF files are copied to the hard drive, and the configuration blue bar goes across the scree...more >>

I recently change the account that sql server runs under. Now I reinstalled the MS Outlook for the new account and configured the exchange server and mail box. Then I went to SQL Server and Support Servers then to SQL Mail and the properties of that. The name of the mail client comes us ...more >>