Post reply

Error Attaching DB

  • April 24, 2008 at 8:08 am

    #121492

    Hi All,

    I got this error when i tried to attach adventureworks DB.Am having SQL Server Developer Edition with SP2 installed.

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

    The database 'AdventureWorks' cannot be opened because it is version 643. This server supports version 612 and earlier. A downgrade path is not supported.

    Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

  • April 24, 2008 at 8:21 am

    #806608

    Ratheesh.K.Nair (4/24/2008)

    Hi All,

    I got this error when i tried to attach adventureworks DB.Am having SQL Server Developer Edition with SP2 installed.

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

    The database 'AdventureWorks' cannot be opened because it is version 643. This server supports version 612 and earlier. A downgrade path is not supported.

    Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    Hello Ratheesh,

    Can you check which version you have downloaded? It might be that you have downloaded the SQL 2008 version and trying to install it on SQL 2005.

    You can download the SQL 2005 databases at this location

    http://www.microsoft.com/Downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

    Hope this helps in troubleshooting.

    Thanks


    Lucky

  • April 24, 2008 at 8:47 am

    #806639

    The error is because you have a newer version of AdventureWorks. I'm guessing the advice above is the issue.

  • April 24, 2008 at 8:48 am

    #806641

    Thanks Lucky thanks a lot ...It worked :w00t:

Viewing 4 posts - 1 through 3 (of 3 total)

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