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!
As mentioned by Kev Riley in your [recent question about migrating] - 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. :
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.
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?