Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Building SQL SERVER 2005 Cluster environment Expand / Collapse
Author
Message
Posted Tuesday, December 8, 2009 8:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:42 PM
Points: 24, Visits: 111
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.
Post #830740
Posted Tuesday, December 8, 2009 9:11 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, June 23, 2014 11:55 AM
Points: 1,708, Visits: 1,792
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.


Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs
Post #830774
Posted Friday, December 11, 2009 2:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:42 PM
Points: 24, Visits: 111
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.
Post #833214
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse