SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrade Strategies for SQL Server 2008


Upgrade Strategies for SQL Server 2008

Author
Message
tstapenhorst
tstapenhorst
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 138
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.
tomas.nelson
tomas.nelson
Valued Member
Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)Valued Member (67 reputation)

Group: General Forum Members
Points: 67 Visits: 150
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?
Sachin Samuel-286731
Sachin Samuel-286731
SSC Veteran
SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)

Group: General Forum Members
Points: 236 Visits: 3646
Good job Arshad. Really liked the article. Keep up the good work.
Fernando-235287
Fernando-235287
Mr or Mrs. 500
Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)Mr or Mrs. 500 (533 reputation)

Group: General Forum Members
Points: 533 Visits: 148
w00tHehe

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?

w00tHehe
Nadrek
Nadrek
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4446 Visits: 2741
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).
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search