SQL Server Clustering

Un-Install a SQL Server Cluster: Step-by-Step

If SQL Server Cluster Install ends up in errors and fails, consider doing a clean up of the cluster install and then re-start it. Here is a step-by-step process which gives a clean un-install of a SQL Server Cluster environment. Step-1 Execute sqlrem.bat Execute sqlrem.bat with following parameters on each node: Syntax: sqlrem.bat <sql install […]

What is New with SQL Server Clustering on Windows 2003

Security Patch – Server Accessibility If latest security patches are not installed on SQL Server, you may see following error message in event log. You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the […]

Gigabit Ethernet Direct Connect Networking

A useful device in Ethernet networking is the cross-over cable. There are circumstances where it is necessary to network two computers together and nothing else. Examples include test environments and clustered systems. In such cases, it is desired to avoid the need for a dedicated network switch. On Ethernet and Fast Ethernet networks, this is […]

How to Implement SQL Server Log Shipping Using Visual Basic

Log Shipping is a Disaster Recovery (DR) tool that provides you the ability to have a readily available “warm backup.” Essentially, should your existing system fail, you have a backup SQL Server and database available to take over with relatively up-to-date information. If your database is critical to your business, such as in a call center, […]

Achieving Massive Scalability with SQL Server

With each release, Microsoft SQL Server continues to gain in performance and scalability. A little known fact buried under Oracle marketing is that SQL Server’s TPC-C score is now even higher than Oracle’s. However, few other than Microsoft have millions of dollars of hardware needed to generate the 709,220 transactions per minute achieved in the […]

How to Upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster

Every time I have to perform some major work on my production SQL Server clusters, I spend a lot of time researching and planning the task at hand. And when it comes to something as big as an upgrade from a SQL Server 7.0 Cluster to a SQL Server 2000 cluster, I even spend more […]

Real Life DBA: Dealing with a SQL Server Cluster Failover

Monday 9:30AM I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived […]

Testing SQL Server 2000 Clusters

If you have successfully gotten this far, most likely the SQL Server 2000 cluster is ready to be used. But before I trust any production systems on a new cluster, it is a good idea to test the SQL Server 2000 cluster to see if it is really working as it should. This section takes […]

Installing the SQL Server 2000 Service Pack

Because of the nature of SQL Server 2000 clustering, you want to ensure that it is as reliable as possible. One of the ways to help ensure that is to be sure that you have installed the latest SQL Server 2000 Service Pack on the SQL Server 2000 Cluster before you put it into production. […]

Installing SQL Server 2000 Clustering

If you have ever installed SQL Server 7.0 in a cluster, you will need to forget what you know, as installing SQL Server 2000 into a cluster is quite different, and in fact, it is much easier.The following steps should be run from the node of the cluster that you consider your primary node. This […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |