Sunday, March 11, 2012

Error 5172 : The Header For File '.....ldf' is not a valid database file header. The pag

Error 5172 : The Header For File '....ldf'' is not a valid database file
header. The pageAudit property is incorret. Plsssssss helppp :(:(:(Hi
Tell use a bit more. Was it on server startup? During normal processing?
Looks like disk corruption to me.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Sadýk Öztürk" <sadiko@.kayzenbilgisayar.com> wrote in message
news:OwoP2B9sFHA.3404@.TK2MSFTNGP09.phx.gbl...
> Error 5172 : The Header For File '....ldf'' is not a valid database file
> header. The pageAudit property is incorret. Plsssssss helppp :(:(:(
>|||i have sql server 2000 and normaly startup and normaly processing. i have
backup mdf and ldf files other directory later formating system and clean
systel install, install sql server and service pack 3 later attach my backup
but failed and erorr the message
Error 5172 : The Header For File '....ldf' is not a valid database file
header. The pageAudit property is incorret.
Plss Hellpppp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uUyiYg9sFHA.4080@.TK2MSFTNGP12.phx.gbl...
> Hi
> Tell use a bit more. Was it on server startup? During normal processing?
> Looks like disk corruption to me.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Sadýk Öztürk" <sadiko@.kayzenbilgisayar.com> wrote in message
> news:OwoP2B9sFHA.3404@.TK2MSFTNGP09.phx.gbl...
>> Error 5172 : The Header For File '....ldf'' is not a valid database file
>> header. The pageAudit property is incorret. Plsssssss helppp :(:(:(
>>
>|||Hi
Looks like the file was not copied cleanly over.
Try attaching the MDF file with the command sp_attach_single_file_db
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Sadýk Öztürk" <sadiko@.kayzenbilgisayar.com> wrote in message
news:Ol5Mmp9sFHA.3328@.TK2MSFTNGP11.phx.gbl...
>i have sql server 2000 and normaly startup and normaly processing. i have
>backup mdf and ldf files other directory later formating system and clean
>systel install, install sql server and service pack 3 later attach my
>backup but failed and erorr the message
> Error 5172 : The Header For File '....ldf' is not a valid database file
> header. The pageAudit property is incorret.
> Plss Hellpppp
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uUyiYg9sFHA.4080@.TK2MSFTNGP12.phx.gbl...
>> Hi
>> Tell use a bit more. Was it on server startup? During normal processing?
>> Looks like disk corruption to me.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Sadýk Öztürk" <sadiko@.kayzenbilgisayar.com> wrote in message
>> news:OwoP2B9sFHA.3404@.TK2MSFTNGP09.phx.gbl...
>> Error 5172 : The Header For File '....ldf'' is not a valid database
>> file header. The pageAudit property is incorret. Plsssssss helppp
>> :(:(:(
>>
>>
>|||i am copy ldf and mdf file copy other directory and partition, later format
and cleaning system install and attach the database but this erorr
plsssss helpppppppppppp
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:O4vAIA%23sFHA.2492@.tk2msftngp13.phx.gbl...
> Hi
> Looks like the file was not copied cleanly over.
> Try attaching the MDF file with the command sp_attach_single_file_db
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Sadýk Öztürk" <sadiko@.kayzenbilgisayar.com> wrote in message
> news:Ol5Mmp9sFHA.3328@.TK2MSFTNGP11.phx.gbl...
>>i have sql server 2000 and normaly startup and normaly processing. i have
>>backup mdf and ldf files other directory later formating system and clean
>>systel install, install sql server and service pack 3 later attach my
>>backup but failed and erorr the message
>> Error 5172 : The Header For File '....ldf' is not a valid database file
>> header. The pageAudit property is incorret.
>> Plss Hellpppp
>> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> news:uUyiYg9sFHA.4080@.TK2MSFTNGP12.phx.gbl...
>> Hi
>> Tell use a bit more. Was it on server startup? During normal processing?
>> Looks like disk corruption to me.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Sadýk Öztürk" <sadiko@.kayzenbilgisayar.com> wrote in message
>> news:OwoP2B9sFHA.3404@.TK2MSFTNGP09.phx.gbl...
>> Error 5172 : The Header For File '....ldf'' is not a valid database
>> file header. The pageAudit property is incorret. Plsssssss helppp
>> :(:(:(
>>
>>
>>
>

1 comment:

Unknown said...

If you don't have latest backup for this database / server I suspect it can not be recovered, you may have only option to fix this by using third party tool to Repair Corrupt MDF File.

Post a Comment