question

Maripili avatar image
Maripili asked

SQL 2000 SP2 SP4

Hi everybody, Need your help and don't have the time to test! I have a big question. I'm migrating a server from a w2003x32 to a W2003x64. The sql still being the same, SQL 2000 Server. But I could see that all my other SQL2000 Servers and this one still having SP2. Right now, for this installation, I require SP4, it says so. First, will I have problems if I restar MSDB and MASTER from the old server? Second, will I have problems if one server has SP4 and the others SP2? Third, if I upgrade SP2 to SP4 in the other servers, will be there some problem? Or is transparent for all? Thanks a lot for your answeres!
sql-server-2000migration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
As mentioned by Kev Riley in your [recent question about migrating][1] - do not migrate msdb and master. You can install an SP, but your database(s) may act differently. The whole idea of an SP is that new features can be introduced, bugs can be fixed and therefore general system behaviour is affected. It may be that some of your DB code will stop working after an SP is installed - this can not be predicted, ***you have to test***. If you don't have time to test, you obviously have the time to repair the system should an upgrade break your DB code. This may not be your decision, but that has to be communicated to the decision makers - the SP install can break your code and cause damage that will take time to fix/rollback to the older system. If I were you, I would not do the migration. I would test more before doing so, especially as you are also going from 32 to 64 bit - the system will definitely behave differently after that switch - and not always positively different. SQL 2000 on 64 bit was not a very nice implementation IIRC. Good luck is all I can say. [1]: http://ask.sqlservercentral.com/questions/28186/migrate-a-sql-2000-to-another-server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Håkan Winther avatar image
Håkan Winther answered
Your worst problem is that you are still running SQL 2000! :) it is not a supported platform and you can't benefit from all of the improvements that have been made in terms of lockings and performance.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
As the others have stated; - dont move system databases - master, msdb, model, and tempdb should be left where they are on the old server and you should use the ones created by the install on the 'new' server. - You cant rely on what a forum says about upgrades, we dont have the systems you are running so we cant predict what issues you may have - try to upgrade from SQL 2000, certainly upgrade to the latest sp for 2000 if you have to stay the reason to upgrade from SQL 2000 is that is it not supported so any problems you do get will be yours to resolve, Microsoft wont open a support call. If you have a vendor saying your SQL version must stay at SQL 2000, do they offer any support?
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Maripili avatar image Maripili commented ·
Ok, i formated and i have the 32bit so again. But here's another ask, if i don't restore msdb and master, how will I get the logins, jobs dts and so on? And, ther's some problem if i begin with a instance name and then i change it, or it will be a problem?
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
@Maripili - on your previous migration question you stated that DTS migration was already successful. The jobs can all be scripted out - there is an option to do this in SSMS and in enterprise manager too (i think). The logins will have to be moved by hand - unless you use windows groups and handle security inside the database this could be quite annoying.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.