SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sql 2000 sp4
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 02/20/2010 :  03:18:16  Show Profile  Reply with Quote
Hi All,

While going for 2000 to 2008 side by side upgrade, is that mandatory to install sql 2000 sp4 service pack in sql 2000 instance and then starting the restoring on SQL 2008 instance????

If so, i want to know the reason behind that?? What all problem will the sp4 will do / help before going for sql 2005/2008 migration??????????

Thanks in Advance.

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/20/2010 :  04:33:36  Show Profile  Reply with Quote
Don't know the answer, but an issue might be that SQL 2000 SP4 is still supported by MS (is that right?) but not any earlier SPack?
Go to Top of Page

wildstyle
Starting Member

United Kingdom
5 Posts

Posted - 02/22/2010 :  07:54:02  Show Profile  Reply with Quote
Microsoft would have tested upgrades to 2005/8 from 2000 on the supported platform at the time . At the time when they did this it was SQL 2000 SP4.

sql 2000 SP4 was release in june 2005.

It is a simple upgrade and will take much less than an hour to complete.

I would not upgrade SQL 2000 SP1/2/3 directly to sql 20005/8. i would be concerned that if you ran it in SQL 2000 compatibility mode, you would experience database issues as that compatibility mode is equal to SQL 2000 SP4.


mainstream support for any version of sql 2000 was retired in august 2008. there is still extended support available until 2013 but this will be for large companies only.

http://support.microsoft.com/gp/lifeselectindex


regards
Gavin
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 02/22/2010 :  08:59:22  Show Profile  Reply with Quote
There were some significant issues with upgrade from SQL 2000 SP3 to SP4 as I recollect it (disastrous query plans where implicit casting was used in JOINs if my memory serves me).

That suggests that a full regression test would be advisable even between Service Packs ...

... and, backward-compatibility mode or not!!, I would not move to a new version of SQL Server without a full regression test ...

... and extrapolating that given that the regression test would be required anyway I would change to latest version [compatibility] so as to have the benefit of new features etc. as well.

But ... for side-by-side that might require regression test for all existing database in order to move them to SP4, plus regression test again when they were moved to SQL 2008.

So we put SQL 2008 on a brand new machine and migrated the DBs to the new server. (Also has the possible benefit that no databases on our SQL 2008 box are running in compatibility mode [I don't know if compatibility mode robs any CPU cycles? e.g. if running a DB in SQL2005 or SQL2000 compatibility on SQL 2008 box?]
Go to Top of Page

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 03/10/2010 :  05:09:41  Show Profile  Reply with Quote
Thank You so much
Go to Top of Page

glennhill
Starting Member

United Kingdom
2 Posts

Posted - 10/16/2012 :  10:32:52  Show Profile  Reply with Quote
This is a very relevant discussion to me but I cannot work out what you concluded.

Does Kristen’s post suggest that we DO NOT need to upgrade to SP4 on a 2000 installation before upgrading to 20008/2008R2, provided we do a database migration to a new installation on a different machine?

We are in that position now. We are installing SQL2008R2 on a new machine and want to migrate our SQL2000 database (that are still SP3a). We would prefer not to have to do an upgrade to SP4 on our old machine before doing the migration.

Any clarification would be very much appreciated.

Thanks
Glenn
Go to Top of Page

glennhill
Starting Member

United Kingdom
2 Posts

Posted - 10/18/2012 :  06:48:00  Show Profile  Reply with Quote
I think I might have answered my own question.

Neither of the following two Microsoft articles:-

"How to: Upgrade a Database Using Detach and Attach (Transact-SQL)"
http://msdn.microsoft.com/en-us/library/ms189625(v=sql.105).aspx

"How to: Restore a Database Backup (SQL Server Management Studio)"
http://technet.microsoft.com/en-us/library/ms177429(v=sql.105).aspx

make any reference to Service Pack level - suggesting to me that SP4 is NOT a requirement for upgrading a database from SQL2000 to SQL2008R2.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000