Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

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?
0
datadirector
Asked:
datadirector
  • 2
1 Solution
 
bcsqlCommented:
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now