Browse by Tags

All Tags » SQL Server (RSS)

114 Days until Windows Server 2008, Visual Studio 2008 and SQL Server 2008...

Are you ready for another OS version? February 27 th , 2008 is the public launch date. Microsoft has a Vista sidebar gadget to help you remember the date - http://www.wedsg.com/winclient/vistasidebargadget/download.htm They seem to love this date, the...

Observations about the software industry today

Sometimes I think that the movie Conspiracy Theory should have been about the software industry today. What has become of it lately? Here is what I believe: · I believe the Anti-Virus companies write all the viruses. · I believe most software is way over...

Windows Server Codename "Longhorn" Beta 3 is out

But if you want to test failover clustering.... Standard SCSI based clustering will no longer work (yes I tested it, no go). Rocket Division StarWind will be the product you want to use to test Failover Clustering. http://www.rocketdivision.com/wind.html...

Clustering terms made easy

Clusters are Highly Available and should never be considered Fault Tolerant. Highly Available = is when I come anytime my wife calls me. Fault Tolerant = Marriage. You don't want to be married to you SQL/Exchange Cluster :) You do want it around whenever...

Your Cluster won’t start and you can’t get into Cluster Administrator

Don’t panic, but you do have a problem. You look under Services and the Cluster service is running on the nodes. Open Cluster Administrator from one of the nodes, but don’t use the name of the cluster, the node name or an IP address, use a period (.)...

Windows Server 2003 Service Pack 2 – the good, the bad, and the ugly

By now you are aware that SP2 is out for Windows Server 2003 and R2. I have already seen quite a few posts in the public newsgroups where people are not aware of a few things. The Good It is a really good idea to backup your system before you attempt...

What I learned at the MVP Summit last week - and I can tell you about!

The 2007 MVP Summit in Redmond/Seattle was awesome. Lots of great content. Here is what I learned: 1) SQL 2005 can cluster with Standard Edition (ok I knew that). What I learned was that you can have multiple SQL instances (that run on 2 nodes only) within...

My Tech Ed 2007 Session - Top 10 Microsoft Windows Server Codename "Longhorn" Failover Clustering Enhancements over Windows Server 2003 Clustering, Based on Best Practices

I was chosen again this year to speak at Tech Ed 2007 - http://www.microsoft.com/events/teched2007/default.mspx Here is the abstract: Be the very first to learn about Windows Server codename "Longhorn" Failover Clustering. Are you using Windows Server...

Surviving the Windows Server 2003 Cluster Bomb, Part II

I can't believe it. Just when you think it's safe to go back to reading the web... Part II of the worst clustering article of all time is out. Back in July ( http://msmvps.com/blogs/clustering/archive/2005/07/21/58509.aspx ) I wrote how bad Part I was...

Having problems installing SQL SP4 on a SQL 2000 Cluster?

Verify that there are no dependencies or extra resources other than those created by the SQL Server setup on any of the SQL Server cluster resources. Resources such as file shares, print servers, etc.must always have a unique network name and an IP address...

SQL 2000a? Does it really exist, or is it a misprint?

After the fun Microsoft had with Slammer a change was made: SQL 2000a does exist and is the current version. SQL 2000a is basically the original disk of SQL 2000 with one DLL replaced to protect against getting the Slammer worm. Windows Server 2003 actually...

Installing a new SQL instance into an existing cluster on a new Node

We added a node to one of our clusters. We confirmed that the hardware, firmware, bios, OS, and installed programs were exactly alike. The new machine joined the cluster like a champ, no issues. When I went to install SQL and create a new instance, I...

Should Clustered services be set to 'manual' or 'automatic'?

The question goes something like this: My cluster is installed and running SQL/Exchange nicely but I noticed that all the services for SQL/Exchange are set to start manaully. Should I set the services to automatic instead? Answer: Cluster controlled services...

Small Business Server (SBS) Clustering

I get this question from time to time: “Does Windows 2003 Small Business Server support clustering and if not would you suggest a 3rd party clustering solution. The only catch I see is the SBS feature of not letting any other SBS servers in the...