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 ««12

Upgrade Strategies for SQL Server 2008 Expand / Collapse
Author
Message
Posted Tuesday, March 30, 2010 2:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 9:18 AM
Points: 7, Visits: 127
Very good article. I have a few questions after reading your article where I'm not clear on for my "Side by Side Upgrade." I'm going to perform the following "check list" of steps from a SQL 2000 SP4 to SQL 2008 in a side by side upgrade:

1. Install SQL 2008 on my new server.
2. Run the SSUA on the new server to find all the issues with the databases on the SQL 2000 server.
3. Clean up any issues reported by the SSUA.
4. Ensure database consistency by running DBCC CHECKDB on all the system and user databases on
the SQL 2000 server.
5. Backup the SQL 2000 databases including the system databases.
6. Restore all the databases including the system databases on the SQL 2008 server.
Question: System databases first then user databases?

Now this is where a big question came to mind when I was reading your "During upgrade" section. This section seems to imply that we are running Setup.exe from the DVD. Is this for an "In-place Upgrade? I got confused reading this section as it relates to my "Side by Side Upgrade" approach. As it is written it seems to imply that I installing SQL 2008 at this point.

7. Revisit SSUA recommendations
8. Update statistices
9. Run DBCC UPDATEUSAGE on all databases, including system databases.

I'm sure I'll find a few "fun" items along the way. Thank you in advance for answering my questions, and helping me get it all clear.
Post #893297
Posted Monday, May 16, 2011 5:48 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 8:48 AM
Points: 6, Visits: 99
Hi...
I have a SQL Server Cluster with 2 nodes configuration in Active / Active mode.
What is the current procedure to made the upgrade process???
I have Default instance in node A and de named Instance in the node B.
I want to upgrade only named instance, i have to failover named instance from node B to node A and run the setup on node B?

Post #1109887
Posted Friday, May 20, 2011 6:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:08 AM
Points: 48, Visits: 3,646
Good job Arshad. Really liked the article. Keep up the good work.
Post #1112311
Posted Friday, May 20, 2011 10:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, July 20, 2012 11:23 AM
Points: 153, Visits: 148


Nice article. One question though, I upgraded from 2000 to 2005 and now we are ready for 2008.

In the 2000 to 2005 I did rebuild the indexes after the upgrade was completed. Do you recommend to do the same from 2005 to 2008?

Post #1112559
Posted Friday, May 20, 2011 6:45 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 11:56 AM
Points: 880, Visits: 2,435
You missed an upgrade method particularly applicable to 2000 to 2008 (R2) conversions:
Machine swap.
You have Server, with SQL2000/5.
You buy/scrounge/spin up a VM NewServer.
You install SQL2008(R2) on NewServer.
You write down the IP's of each, then swap their IP's, swap the names, rejoin the domain if applicable, and change the SQL Server name.

Wait N days, then get rid of Server (old).
Post #1112824
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse