Home Forums SQL Server 2012 SQL 2012 - General Restore databse from SQL SERVER 2005 to SQL SERVER 2012. RE: Restore databse from SQL SERVER 2005 to SQL SERVER 2012.

  • July 10, 2013 at 2:20 am

    #1631109

    vinod.venugopal 71189 (7/9/2013)

    I thought SQL Server 2005 has to be on SP4 or above before we plan to migrate/restore it to SQL 2012.

    Thanks for clarifying my doubt. I will also definitely consider using above scripts.

    --Vinod

    i think that might be true for an in place upgrade, but when just doing backup and restore on the new 2012, then it's not necessary

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!