• SQLSACT (6/18/2013)


    As for restoring backwards (restoring a database from a newer version to an older one) is not supported. I think it is possible but not pretty.

    It's not that it's not supported, it's outright not possible, pretty or otherwise. You have to recreate the DB on the lower version.

    Not that the OP asked about restoring to a lower 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