April 14, 2011 at 10:36 am
We are going to upgrade our SQL Server 2000 (no SP) to SQL Server 2008 R2. Since I do not see any upgrade path for this specific configuration on the Microsoft site, does this mean I have to apply Service Paks to the 2000 instance before upgrading to 2008 R2? I am planning to use the detach/attach method. Thanks for your assistance.
April 14, 2011 at 12:54 pm
I know to upgrade to 2005 the SP level for 2000 had to be SP4 or you could not select the instance for upgrade. I would assume the same holds true going to 2008.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 14, 2011 at 1:58 pm
Thanks for responding. Not what I wanted to hear but I am glad to know BEFORE I start the upgrade.
April 15, 2011 at 6:00 am
If you're doing the detach/attach, you might (might) be able to get away with it. Test it before-hand. You should test everything anyway.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 18, 2011 at 1:23 pm
Hi -
I have just successfully upgraded a sql 2000 sp2 database to sql 2008 r2 using the backup and restore method. I upgraded the database from sql 6.5 to 2000 back in 2003, so there were some sproc that had some ancient code that had to be changed, but the move went well.
April 18, 2011 at 1:49 pm
Glad to hear it worked. Did you patch the server first?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 18, 2011 at 1:54 pm
no, I didn't. I DO remeber reading somewhere that sql 2000 should be on sp4 before the upgrade... but I guess I had a senior moment. The old DB is still running and I just did select @@version to check and its on sp2.
I did 3-4 "practice" moves and some significant testing, and all seems well. Maybe I just got lucky.
April 18, 2011 at 2:03 pm
Thanks for the input. Strangely enough, that server went down over the weekend due to a hardware failure so now we are looking at restoring the databases to a different server rather than performing an upgrade.
April 18, 2011 at 2:21 pm
Uripedes Pants (4/18/2011)
no, I didn't. I DO remeber reading somewhere that sql 2000 should be on sp4 before the upgrade... but I guess I had a senior moment. The old DB is still running and I just did select @@version to check and its on sp2.I did 3-4 "practice" moves and some significant testing, and all seems well. Maybe I just got lucky.
I thought you could get away with it, but I wasn't sure, not having tried it. I know it doesn't work for an in-place upgrade. Yet another reason not to do those crazy types of upgrades.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply