Post reply

Restoring SQL 2008 EE DB to SQL 2008 SE ..

  • July 26, 2011 at 1:21 am

    #254850

    Hi,

    I am trying to restore SQL2008 Enterprise Edition DB backup to SQL2008 Standard Edition DB, but I am not able to restore it. Its throwing error. Is it possible to do it? Please show some way to do it...

  • July 26, 2011 at 1:42 am

    #1358273

    And the error message is....????

    It's possible providing you have no persistent Enterprise-only features in use in the DB.

    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

  • July 26, 2011 at 2:32 am

    #1358293

    and the error message is "An Exception occurred while executing a Transact-SQL statement or Batch."

  • July 26, 2011 at 2:48 am

    #1358300

    Do you have any persistent Enterprise-only features in your database?

    Use sys.dm_db_persisted_sku_features to see. If you do, you won't be able to restore to standard or lower unless you remove them.

    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 4 posts - 1 through 3 (of 3 total)

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