Friday, February 17, 2012

Error attaching database

I detached a database to copy the files and when I tried to re-attach it
failed with:
/ ****************************************
/
Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1374
Expression: m_nVars > 0
SPID: 55
Process ID: 952
Connection Broken
/ ****************************************
/
I'm pretty sure this is a disk problem. Is there anyway to re-attach this db
in emergency mode? Like you can with a suspect database.
Any help would be appreciated,
DougSIf going back to backup is not an option, then you may want to contact
Microsoft PSS. They maybe able to help you rebuild the transaction log.
However, the database may still be corrupted and depending on the extent of
the corruption, you may or may not be able to repair or extract data out.
Yih-Yoon Lee
On Wed, 24 Mar 2004 11:51:24 -0500, Doug Stiers wrote:

> I detached a database to copy the files and when I tried to re-attach it
> failed with:
> / ****************************************
/
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: recbase.cpp:1374
> Expression: m_nVars > 0
> SPID: 55
> Process ID: 952
> Connection Broken
> / ****************************************
/
> I'm pretty sure this is a disk problem. Is there anyway to re-attach this
db
> in emergency mode? Like you can with a suspect database.
> Any help would be appreciated,
> DougS

No comments:

Post a Comment