Post reply

restoring System Databases - From SQL Server 2005 into SQL Server 2008R2

  • October 3, 2014 at 10:59 am

    #290630

    Can this be done?

    I put my new 2008 R2 instance in single user mode and then attempted to restore a backup of the master database taken in my 2005 instance.

    I get an error saying:

    Restore failed for Server 'myserver'. (Microsoft.SqlServer.SmoExtended)

    System.Data.SqlClient.SqlError: The backup of the system database on the device C:\Temp\Backups from DEV\master_backup_201410030710.bak cannot be restored because it was created by a different version of the server (9.00.4035) than this server (10.50.4266). (Microsoft.SqlServer.Smo)

  • October 3, 2014 at 11:15 am

    #1750043

    No, it cannot, as the error message says.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 3, 2014 at 11:46 am

    #1750055

    so basically I will just need to rebuild my users and jobs, etc.. then bring over my user databases.

    Thanks!!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply