Home Forums SQL Server 2008 SQL Server 2008 - General SQL Restore from SQL Express backup? RE: SQL Restore from SQL Express backup?

  • October 5, 2013 at 1:59 pm

    #1656107

    Nothing to do with SQL Express.

    You have a SQL 2008 R2 backup that you're trying to restore to a SQL 2008 instance (not R2). They're two different versions and you can never restore down-version. You can restore up-version or between editions on the same version, but not down-version.

    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