none
I have an error when I attach my database RRS feed

  • Question

  • Hi guys before I formatted my computer I move my database to my Local Disk D: then I formatted my computer and now I have installed SQL Server and I try to attach my database and then It gives this error  I really don`t know what to do  I have read some solutions from Forum but It did not work I tried to run as an Administrator again It did not work

    An error occurred when attaching the database(s).  Click the hyperlink in the Message column for details.

    for error details 

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------


    Attach database failed for Server 'MANISARUS-PC\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)


    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476


    ------------------------------
    ADDITIONAL INFORMATION:


    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


    ------------------------------


    The database 'phoneBook' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
    Could not open new database 'phoneBook'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)


    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476


    ------------------------------
    BUTTONS:


    OK
    ------------------------------

    • Edited by Zerhan Thursday, March 29, 2012 12:13 PM
    Thursday, March 29, 2012 12:02 PM

Answers

  • The database 'phoneBook' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
    Could not open new database 'phoneBook'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    your database phoneBook was previously attached to a newer version than you now have installed.

    I think you've used SQL 2008 R2 (661) and now you've installed SQL 2008 SP1 (655) only.

    Remember that you can't attach database from higher SQL Server to a lower SQL Server version number.

    see this blog

    http://www.sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx


    • Edited by Daniel_Steiner Thursday, March 29, 2012 2:33 PM
    • Proposed as answer by KevinNicholas Thursday, March 29, 2012 9:39 PM
    • Marked as answer by Zerhan Tuesday, April 3, 2012 1:32 PM
    Thursday, March 29, 2012 2:31 PM

All replies

  • The database 'phoneBook' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
    Could not open new database 'phoneBook'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    your database phoneBook was previously attached to a newer version than you now have installed.

    I think you've used SQL 2008 R2 (661) and now you've installed SQL 2008 SP1 (655) only.

    Remember that you can't attach database from higher SQL Server to a lower SQL Server version number.

    see this blog

    http://www.sqlskills.com/BLOGS/PAUL/post/SQL-Server-2008-R2-bumps-the-database-version.aspx


    • Edited by Daniel_Steiner Thursday, March 29, 2012 2:33 PM
    • Proposed as answer by KevinNicholas Thursday, March 29, 2012 9:39 PM
    • Marked as answer by Zerhan Tuesday, April 3, 2012 1:32 PM
    Thursday, March 29, 2012 2:31 PM
  • Thanks It worked for me
    Tuesday, April 3, 2012 1:33 PM