Restore SQL 2005 Enterprise backup to SQL Express 2005

  • Hi,

    Is it possible to restore a full backup created on SQL 2005 enterprise to a SQL Express edition?

    Thanks

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • ????????????:w00t:

  • It should be, providing the database doesn't use any features not supported in Standard and is no larger than the DB size limit on Express (4GB)

    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
  • Excellent!!! Thanks for the information, Gail.

    I am getting an enterprise bak copy from a client this afternoon and I will post the results to this thread for future reference.

    Thanks,

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • MostInterestingMan (8/19/2010)


    Excellent!!! Thanks for the information, Gail.

    Emphasis 'should'. I don't have an express instance around to try it out on.

    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
  • GilaMonster (8/19/2010)


    MostInterestingMan (8/19/2010)


    Excellent!!! Thanks for the information, Gail.

    Emphasis 'should'. I don't have an express instance around to try it out on.

    Yep.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

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

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