Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Side by Side in Cluster ..Creating new resource group Expand / Collapse
Posted Friday, December 24, 2010 9:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 11, 2012 12:47 PM
Points: 27, Visits: 329
Hi all

I new to SQL Server Cluster,I have a Windows 2003 SP2 with SQL Server 2000 SP4.
now I have to add new SQL Server 2008R2 instance to excisting cluster.I prepared document.

1. Upgrading shared componets in both nodes (start from Passive node)
a.Upgrade shared components in passive node (Node 2)
b.restart passive node 2
c.Do the fail-over (Node 1 to node 2)
d. Upgrade other node 1
E. restart the upgraded node 1.

2.Start the installation again from Passive node

1.I have to new create Resource group and I have to add the drives to the gorup
2.and then moving the drives passive node( by using fail-over).
3.then start SQL Server 2008 r2 installation

my question is
how to create new resouce group ?
How adding the drives ?
How to start instllation in passive nodes?

Can some body help with steps if possible...
Post #1039127
Posted Friday, December 24, 2010 9:23 AM



Group: General Forum Members
Last Login: Yesterday @ 9:37 PM
Points: 5,911, Visits: 10,366
Have you checked out the SQL Server 2008 Upgrade Technical Reference Guide?

Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1039133
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse