"Attempt to fetch logical page" during attaching

29 Jun 2006 8:56 AM

Angelo Brusati

Hi everybody

As my SQL server had some problems, I had to reinstall it.
Once reinstalled, I wanted to attach the original .mdb and .ldf files, but I
got the error message: "Attempt to fetch logical page during attaching".

I'm lost. How can I solve this problem?

Thanks

/Angelo

29 Jun 2006 9:01 PM

Tibor Karaszi

Did you detach the database before re-installing? If not, attach isn't guaranteed and you should
restore from backup instead.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Angelo Brusati" <ang***@intrasuite.net> wrote in message
news:eTm$vm1mGHA.4960@TK2MSFTNGP04.phx.gbl...
> Hi everybody
>
> As my SQL server had some problems, I had to reinstall it.
> Once reinstalled, I wanted to attach the original .mdb and .ldf files, but I got the error
> message: "Attempt to fetch logical page during attaching".
>
> I'm lost. How can I solve this problem?
>
> Thanks
>
> /Angelo
>

29 Jun 2006 11:11 PM

Robespierre Maia Sá

Tibor Karaszi wrote:

>Did you detach the database before re-installing? If not, attach isn't guaranteed and you should
>restore from backup instead.
>
>> Hi everybody
>>
>[quoted text clipped - 7 lines]
>>
>> /Angelo

Yes. You just can attach any database if you detached before or stopped the
SQLservice. I think you reinstalled SQL with databases in use. Please tell us
more details.