SQL Server Performance Forum – Threads Archive

Moving Database with server SP levels different

We are finally migrating some databases from an older SQL 2000 SP2 box to a newer (hardware) SQL 2000 SP3A box. Is there any issue when moving a database if one server is at SP2 and another server is at SP3a+ (version 800.081<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Thanks Doug

As far I know, no.
But you have to update statistics to all databases in new box. That is the first step to keep performance.
Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

Update statistics AFTER I attach the databases or before I detach from the previous server??? If after I attach can you tell me the best way to do this? Thanks Doug

I get really nervous about doing stuff like this. If I was you, I would take the extra 15 minutes and just apply the latest service pack. It might save you a lot of headache later on down the road. Just my 2 cents. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.

Ensure to maintain similar versions of service packs & MDAC versions to overcome issues, as specified. Its suggested to run DBCC checks before detaching and after attaching run UPDATE stats to take care of performance. Review information from books online in this regard. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>