Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    china
    Posts
    1

    Unanswered: EXEC sp_attach_db have a error

    I entered the following in the Query Analyzer and got the result shown:

    EXEC sp_attach_db @dbname = N'DS2004',
    @filename1 = N'd:\ds2004_data.mdf',
    @filename2 = N'd:\ds2004_log.Ldf'

    Server: Msg 5172, Level 16, State 15, Line 1
    The header for file 'd:\ds2004_data.MDF' is not a valid database file header. The PageAudit property is incorrect

    I can find nothing about PageAudit property.

    What is it and how do I need to modify the command?

    Many thanks
    Last edited by jianyao; 02-02-04 at 20:34.

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    I believe the message is trying to tell you that the PageAudit property of the database file header property in ds2004_data.mdf is bad. I think your command is okay, but you have a corrupted file.
    -bpd

  3. #3
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    Maybe you're trying to detach a SQL 2k db and restore to SQL 7.0? It doesn't work. Attach or restore a sql 2000 database to version 7.0 is not supported.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •