locked
How to fix corrupt database? RRS feed

  • Question

  • Hello,

    I am trying to run the example program: Coding4Fun: Building a Family History Web Service at this URL

    http://msdn.microsoft.com/coding4fun/xmlforfun/familyhistory/default.aspx

    The project has an SQL Express database Family.mdf.  When I try and open Family.mdf in VS 2005, I get this error:

    'FAMILY.MDF' cannot be upgraded because its non-release version (587) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.

    I can create a new database, but then the stored procedures will be lost.

    Any suggestions how to repair the database?

    Thanks

     

    Wednesday, October 4, 2006 2:25 PM

Answers

  • That database was based on a beta build. Beta build were not supposed to be supported after the RTM version is launched. Í dont´think that there is a upgrade path for this internal version to the RTM version. If you still have a beta SQL Server 2005 (Yukon) you can try to attach the db to that one and script the structure out.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, October 4, 2006 3:22 PM

All replies

  • That database was based on a beta build. Beta build were not supposed to be supported after the RTM version is launched. Í dont´think that there is a upgrade path for this internal version to the RTM version. If you still have a beta SQL Server 2005 (Yukon) you can try to attach the db to that one and script the structure out.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
    Wednesday, October 4, 2006 3:22 PM
  • Hello Jens,

    Thanks for taking time to reply to this question. I dont have a beta version of SQL 2005, so I guess I will have to just create a new database.

    Thank you,

    Tom

     

    Wednesday, October 4, 2006 3:31 PM
  • Thank you for sharing such a useful question.
    Tuesday, July 28, 2020 8:41 AM