We have a 3 node a/a/p cluster setup for SQL Server 2005 with SP3.
Node1 have 1 instance and node has 4 instances and node3 is passive.
Databases on Instance1 on node1 have log ship configured and the databases are in restore mode on a secondary server ServerA.
Databases on Instance2,3,4,5 on node2 have log ship configured and the databases are in restore mode on a secondary server ServerB.
Now we need to peform in-place upgrade to SQL Server 2008:
1. Do we need to first disable Logshipping on all nodes and bring the secondary databases online on ServerA & ServerB and upgrade the instances on ServerA & ServerB to SQL Server 2008?
2.Then Perform the in-place upgrade on Clustered nodes to SQL Server 2008.
3. Take the full backup on Primary instances and copy to secondary, delete the existing databases on ServerA & B.
4. Restore the databases with NORECOVERY and configure log shipping again?
I already went through the MS upgrade guide SQL2008UpgradeTechnicalReferenceGuide.docx but I'm http://www.sqlservercentral.com/Forums/Skins/Classic/Images/RichTextBoxTable/tbl_bottomleft.gifNOT clear the steps discussed.
So please the DBA gurus who did the in-place upgrade under similar scenario, share your experience
Thanks in Advance!