MS SQL Server 2005 SP2 and SP3 upgrade

We're going to be migrating to a new SQL Server 2005 Standard Ed. with SP3 already installed, however our current production server and mirror server both have SP2 installed.  Will there be any issues in moving the databases from a server with SP2 to one with SP3? Or should we upgrade our production server to SP3 before migrating?
datadirectorAsked:
Who is Participating?
 
bcsqlConnect With a Mentor Commented:
Yes you can move a database from a SP2 instance to a SP3 instance , I have done it with no problem. While there "should be" no issue with your app on SP3 I would test it first.
0
 
reb73Commented:
When you say move - are you implying a detach/attach or a backup/restore of user databases?

If yes, as far as I'm aware, there shouldn't be any problems as such.. Though upgrading the existing ones to SP3 before the move would be ideal..
0
 
datadirectorAuthor Commented:
We plan on doing a detach, copy & paste to the new server and then re-attach the database.
0
 
reb73Commented:
Should be ok then, but test it initially as advised by bcsql..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.