Monday, March 19, 2012

HELP! I/O error (torn page) when attaching mdf and ldf files

We are using cloning software to directly backup the mdf and ldf files. I am
testing a restore of these files by using sp_attach_db.
When I do this I am receiving an error on the ldf file: See below:
Server: Msg 823, Level 24, State 6, Line 1
I/O error (torn page) detected during read at offset 0000000000000000 in
file 'D:\Data\FRPP01_log.ldf'.
Connection Broken
Please help........Your clone is no good. It was taken during while a page was partially
written.
You need to have your clone software interact with the SQL VDI (Virtual
Device Interface) that will quiesce database writes for a moment while the
clone occurs. You need to contact your clone software vendor to see if they
support this technology and if so, how to enable it for your environment.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Kristen" <Kristen@.discussions.microsoft.com> wrote in message
news:3ED62BD7-738E-4399-A845-98BA25919E53@.microsoft.com...
> We are using cloning software to directly backup the mdf and ldf files. I
> am
> testing a restore of these files by using sp_attach_db.
> When I do this I am receiving an error on the ldf file: See below:
> Server: Msg 823, Level 24, State 6, Line 1
> I/O error (torn page) detected during read at offset 0000000000000000 in
> file 'D:\Data\FRPP01_log.ldf'.
> Connection Broken
> Please help........

No comments:

Post a Comment