MS SQL Server 2005 SP2 and SP3 upgrade

Posted on 2009-04-16
Last Modified: 2012-05-06
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?
Question by:datadirector
    LVL 6

    Accepted Solution

    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.
    LVL 25

    Expert Comment

    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..

    Author Comment

    We plan on doing a detach, copy & paste to the new server and then re-attach the database.
    LVL 25

    Expert Comment

    Should be ok then, but test it initially as advised by bcsql..

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now