Post reply

The database cannot be opened because it is version 706. This server supports version 661 and earlier

  • October 1, 2014 at 5:06 am

    #290450

    Today I was trying to attach a database in SQL server 2008 R2.

    I got an error while attaching database:

    Below i attached the screenshot of the error please help me to resolve it

  • October 1, 2014 at 5:12 am

    #1749353

    You are trying to attach SQL Server 2012 database file to SQL Server 2008. The only solution to this problem is to generate script from SQL server 2012 and than run that script in SQL server 2008.

    SSMS Expert

  • October 1, 2014 at 5:46 am

    #1749365

    enriquemallon (10/1/2014)

    Today I was trying to attach a database in SQL server 2008 R2.

    Databases cannot be downgraded, you need to attach it to SQL Server 2012 or SQL Server 2014

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

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