Achieve High Availability With Log Shipping in SQL Server 2000
While clustering is a useful high availability solution, sometimes it may be overkill, and it is very expensive. Database administrators can use log shipping in place of cluster to provide high availability
Co-existence of SQL 2005 with SQL 2000
SQL 2000 IA64 edition was released in tandem with SQL Server 2000 Service Pack 3 (SP3). In SQL Server 2000, the identification of the server connection endpoints is If you are running a 32-bit OS on x86 hardware based cluster,
MSDTC and SQL Server on a cluster
Before installing SQL Server 2005 on a failover cluster, Microsoft strongly recommends that you install and configure Microsoft Distributed Transaction Coordinator (MS DTC) on Windows 2000 and Windows Server 2003 operating systems.
FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL
Microsoft SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node. You try to uninstall SQL Server 2000 build 2187 by using Add or Remove Programs. In this scenario, you cannot uninstall SQL Server 2000 build
Explore the benefits and drawbacks of clustering SQL Server 2000
A Microsoft service called Microsoft Cluster Services (MSCS) is used to manage the clustered server(s). A SQL Server cluster is a virtual server composed of two or more server machines (nodes) running SQL Server.
Microsoft System Administrator
Design, optimize, support and maintain all SQL Server database systems. systems and MS SQL Server 2000 and MS SQL Server 2005 replication and updated databases. Knowledge about Microsoft or equivalent cluster technologies.
Microsoft programs CDs and DVDs, updated 2006-NOV-05
C 2723A MS SQL SERVER 2K FOR EXPERIENCED DB PROF.TRAINER 11 882 AppDev SQL Server 2000 Accelerated Training [3 CDs] 11 298 SQL Anywhere Studio V8 (c) Sybase DEPCKAQQREAC000029800715933513-00-0800-01
SQL Server links I have referenced lately and a few OS ones
Most are SQL Server related, with a few OS ones thrown in for good measure. Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 configuration on a cluster server; SQL Server 2000 and SQL Server 2005
Sidetracked with MySQL & SQL Server Performance
We'll be using a database cluster for our primary work and smaller database servers to set up SQL Server 2000 and the test ran in 0.3 seconds (again, all locally). NET / SQL Server solution on the same hardware would compare.
Tomcat, DBCP, and SQL Server Connection Pooling
Well something is either really wrong with SQL Server 2000, the SQL Server 2000 JDBC This seems to take place when something happens on the SQL Server side, Also, it wouldn’t hurt to cluster SQL Server since our entire shop (the