Building SQL SERVER 2005 Cluster environment

Question

Building SQL SERVER 2005 Cluster environment

Kasnut

Old Hand

Points: 366
More actions
December 8, 2009 at 8:42 am

#137481

I was trying to get steps to efficiently rebuild a sql server 2005 cluster environment on Windows 2008. Currently on Windows 2003 and sql server 2005. There are stability issues with the current step up. I want to rebuild the environment that has approximately 25 databases. What are the steps involved? What to do or How to move over the databases form the other environment ? Any help will be appreciate.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

The first thing would be to validate that your hardware supports SCSI-3 persistent reservations commands which are required for clustering Windows 2008.

Windows 2008 Failover Cluster Validation Fails on Validate SCSI 3 Persistent Reservation

If this is the first time you've built a cluster from scratch you might take a look at a blog post I wrote earlier this year on building a test cluster for learning:

Building a SQL Server Cluster for Testing

Moving the databases once the cluster is up depends on how you plan on doing this. You could move the data drives between servers which would save downtime, but this could be a one way process and leave you with no fail back plan except to restore from backup. If you are going from SQL 2005 to SQL 2005 this wouldn't be as big of a concern but definitely something to be mindful of if you are going from SQL 2005 to SQL 2008.

Kasnut Old Hand Points: 366 More actions · Answer 2

Thanks. I'm moving from SQL 2005 to SQL 2005. The windows 2008 cluster is already built. Just move the drives or what to do with the master database and so forth. Need a step by step process. I'm installing SQL 2005 also. Any settings that I need to be aware of would be helpful.