Results 1 to 4 of 4

Thread: Error 5172

  1. #1
    Join Date
    Oct 2005
    Posts
    7

    Unanswered: Error 5172

    Hello,

    I hava an sql server 2000 sp3a on a win2k sp4 machine running all ok. I tried to build a raid 1 using the hdd where sqlserver was and a new one, but i failed to build it and consecuently i lost all data bases.

    Using some programs, i recover the mdf, ldf and ndf files from my old sql server 2000.

    I reinstalled all the system exactly the same, win2k sp4 and sql server 2000 with sp3a ( i know sp4 is out ), installed all the apps and overwrites mdf,nfs and ldf files with the old data, and when i tried to put databse online i get this error:

    error 5172: header not valid on file "C:\dbtest.mdf". Pageaudit property is not valid.

    Any one can help me?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    http://www.dbforums.com/t749523.html
    http://www.lazydba.com/sql/1__728.html

    There's lots of stuff out there...just google it....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2005
    Posts
    7
    well, i've tried this before post with no result. i just ask here becouse i'm very lost.

  4. #4
    Join Date
    Oct 2005
    Posts
    7
    I tried command:

    exec sp_attach_db @dbname .... with so meny variation and i get the same error. Can anyone help me?

    Thanks.
    Last edited by alberich; 11-30-05 at 15:18.

Posting Permissions

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