Post reply

Restore SS 2008 R2 database to SS 2008 R2 Standard Edition

  • November 15, 2011 at 7:47 pm

    #260044

    Hello, I need to take a backup of my existing SQL Server 2008 R2 Express database and restore it to a SQL Server 2008 R2 Standard Edition database. I was wondering if there will be any issues with this.

  • November 15, 2011 at 9:37 pm

    #1408247

    No you wont face any issue it will be restored properly

  • November 16, 2011 at 12:01 am

    #1408262

    Edit: Express not Enterprise...

    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

  • November 16, 2011 at 12:19 am

    #1408272

    GilaMonster (11/16/2011)

    Providing you're not using any of the persistent Enterprise-only features (TDE, Compression, partitioning), it will restore fine. If you're using any of those, the restore will fail at the end.

    OP is planning to backup DB (Express Edition) & restore in Standard. He didn't mention Enterprise edition.

    Also it's restore form Lowest Edition (Express) to Higher Edition (Standard). I don't see any issue in it.

  • November 16, 2011 at 5:55 am

    #1408412

    Would I be able to install SQL Server 2008 R2 Standard Edition on the same server as the current SQL Server 2008 R2 Express Edition?

  • November 16, 2011 at 6:03 am

    #1408422

    Yes. SQL Server support side-by-side installations of different versions / editions.

    Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008

    http://msdn.microsoft.com/en-us/library/ee210714.aspx

Viewing 6 posts - 1 through 5 (of 5 total)

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