Post reply

Confusion w/Attach DataBase mdf errors

  • October 3, 2005 at 7:58 pm

    #91342

    I recently had to upgrade my OS harddrive which contains all of my applications. After successfull install I had to also reinstall my MSSQL Developer 2000 application. I can now access the provided databases such as Northwind ect. . . I was also developing other databases and attempted to point to them thru (Righ-Click All Task-->Attach) context menu. I selected the Database that I wanted and verified the files. When I press I get the following error message:Error 5172: The header for file 'I:\MSSQLLogs\BookShopDB_Log.LDF' is not a valid database file header. The PageAudit property is incorrect.? I get lost from this point as to how to resolve this problem. Can someone provide some help? Thanks in advance . . . .

    Tom Johnson

    Kindest Regards,

    Thomas Johnson
    A+, MCP, MCSD .Net, C#
    Pray to the one who scraficed for you

  • October 3, 2005 at 10:18 pm

    #594714

    Don't know if the log file is corrupt or not, but you could use sp_attach_single_file_db (look it up in bol) stored proc which will recreate the log file if the database only had one log file.

  • October 3, 2005 at 11:01 pm

    #594721

    Take a look at RESTORE VERIFYONLY in Books Online.

     

    --------------------
    Colt 45 - the original point and click interface

  • October 4, 2005 at 12:14 am

    #594728

    Thanks Andrew, your suggestion seemed to fit the bill for what I wanted to do. This feature simply reconized that the original log file was corrupt and built a new version.

    Kindest Regards,

    Thomas Johnson
    A+, MCP, MCSD .Net, C#
    Pray to the one who scraficed for you

  • October 4, 2005 at 12:16 am

    #594729

    Thanks Phil, I found a useful purpose for your suggestion as well.

    Kindest Regards,

    Thomas Johnson
    A+, MCP, MCSD .Net, C#
    Pray to the one who scraficed for you

  • June 8, 2006 at 4:04 am

    #642463

    i have same problem. if you will find any solution, please forward to me.

  • June 8, 2006 at 4:04 am

    #642462

    i have same problem. if you will find any solution, please forward to me.

Viewing 7 posts - 1 through 6 (of 6 total)

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