Post reply

Restore database cross edition

  • October 9, 2012 at 7:56 am

    #269041

    Hi,

    I have two servers, one having SQL Server Standard Edition 2008 R2 and the other one having SQL Server Enterprise Edition 2008. I am not able to restore database backup of standard edition on enterprise edition.

    Can someone please tell me that is there any option to restore database backup cross edition in sql server 2008?

    Thanks & Regards,

    Kumar Anand

  • October 9, 2012 at 8:36 am

    #1547242

    You cannot restore down-version ever. It's not about standard edition and enterprise, it's because you're trying to restore a 2008 R2 DB onto SQL 2008.

    Script objects, export data, recreate DB on SQL 2008.

    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

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

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