Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2010-02-20 : 03:18:16
|
| 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
22859 Posts |
Posted - 2010-02-20 : 04:33:36
|
| 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? |
 |
|
|
wildstyle
Starting Member
5 Posts |
Posted - 2010-02-22 : 07:54:02
|
| 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/lifeselectindexregardsGavin |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-22 : 08:59:22
|
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?] |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2010-03-10 : 05:09:41
|
| Thank You so much |
|
|
|
glennhill
Starting Member
2 Posts |
Posted - 2012-10-16 : 10:32:52
|
| 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.ThanksGlenn |
|
|
|
glennhill
Starting Member
2 Posts |
Posted - 2012-10-18 : 06:48:00
|
| 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).aspxmake any reference to Service Pack level - suggesting to me that SP4 is NOT a requirement for upgrading a database from SQL2000 to SQL2008R2. |
|
|
|
|
|
|
sql 2000 sp4