Figured I'd make my first post not just an introduction, but also give some usefull information on SQL cluster installations that isn't documented very well.
Let's start with the introduction. I am Bertrand Rohrbock, 25 years old and working for Info Support as a DBA (Database Administrator) with a large insurance company in the Netherlands. I am in the team that runs one of the largest if not the largest SQL server farm in the Netherlands with nearly 200 instances serving over 3900 databases. My daily work varies from monitoring the status and performance of our servers and designing and implementing structural fixes to working with internal clients to make sure their solutions run well on our platform.
We currently run both SQL 2000 and SQL 2005 instances on our platform and are in the (slow) proces of migrating everything to SQL 2005. However as the release date of SQL 2008 is coming up pretty fast a lot of projects will skip the 2005 release and migrate directly to SQL 2008. Another product I work a lot with is Red Gate SQL Backup Pro and as we have some problems with this product and my colleagues like to dump all of them on me I'm likely to write about it some.
Beside all the technical aspects of the DBA life ( it's not a job, it's a way of life 😉 ) there's a lot of proces improvement going on as the organisation moves from CMM level 2 to 3. It's increasingly becoming a part of my job to make sure the proces is done right and as with all change this sometimes leads to frustrations for me or our clients which I might elaborate on occasionally on this blog.
Now for the usefull information: During the installation of two new instances on one of our production clusters the other day I ran into a problem. I am not sure if this problem exists in one form or the other with normal (non-clustered) installations !
SQL Server 2005 wants you to reboot the system it's installed on after installation, but I did not have this option at the time (even though the installation was during a maintenance window) and it works just fine without the reboot. However the installation puts the system in a 'reboot pending' state which is detected when installing a new instance. The setup gives a nice red cross at installation ( Pending Reboot Requirement ), but still gives the option to move on. However at the point in the installation where the nodes are selected the nodes on which another instance has been installed will be in the unavailable listbox and give the error 'a scc check failed on the node'.
The sollution is to delete (or rename if you're uncomfortable with deleting) the following registry key on both nodes and log out:
It's a good idea to do this after every installation even after installing a single instance. The pending reboot state does not only affect SQL Server, but the entire system, there can be problems with rolling out security patches for example. Obviously it's best to reboot the system after you're done installing, but this option is not always available. It should be best practise to leave the system in the state it was in before the installation.
Welcome Bertrand to the blog community, I’m pretty sure it’s going to be interesting 🙂
I’m not really a DB kinda guy, I can implement a database, but managing 3900 databases is a bit too much for my liking ;P.
I got a good tip on moving/deleting the pending file rename operations node from the registry. Export them first, this way it’s easier to restore them if you mess up the installation anyway.
Good tip, I usually rename them and then delete them afterwards, but exporting is a much cleaner method.
Sounds like it’s easy if you write some kind of tool for this so we don’t have to rename (or delete) them manually every time.
Geert van Horrik
My name is Helen Joyce and I manage the development of SQL Backup at Red Gate Software. I read on your blog that you have been experiencing some problems with SQL Backup Pro and sounds like you are having to handle them! I would be keen to hear from you so that we can resolve the problems you have encountered. Do feel free to get in touch at the SQL Backup Pro support forum to tell us more or contact our support team on +44 (0)870 160 0037 / e-mail support @ red-gate.com. As this is not our usual customer experience of the tool, we would be pleased to help you as soon as possible.
With best wishes,
I stumbled across your blog at the end of the PASS conference. I’m wondering if you can tell me if any of the shared components of the default 2005 instance lose availability when installing a named instance?
Sorry for the late response, I didn’t see your comment till now.
The answer is no. They won’t lose availability.
I required some info regarding the replication of our SQL Server environment.
We currently have a Clustered environment running SQL Server 2000 clustered instance.
Now we want to create a New Cluster running SQL Server 2005 clustered instance with the SAME Name, IP as of the current environment.
This is to migrate my databases to SQL Server 2005 without changing the database name,IP.
Can it be done by taking the previous environment offline and installing new sql 2005 instance?
Please provide the reference also.
I must say I haven’t tested it, but I forsee problems with software compatibility. We always migrate to a differently named server when migrating from 2000 to 2005 because not all applications can handle the change.
If you don’t change the servername there might be applications that connect to your server without your knowledge (yea that’s bad, but it happens) that will start to fail once you’ve moved.
Microsoft has written some articles on the subject of upgrading SQL, you can find one of them here http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx .
Upgrading SQL is not something you should take lightly, it has a lot of impact on your applications !