Tuesday, March 20, 2012

[Ugent] attach Database error in SQL 7.0

Dear All
I have try to detach and re-attach database from SQL7.0 (Production Server).
The detach process was success, but re-attach database occur a error. There
is a Error message show on my screen.
----
--
Changed Language setting to us_english.
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:3882
Expression: pPage->GetLsn () == lp -> GetPrevPageLsn ()
SPID: 9
Process ID: 148
Connection Broken
----
--
Do anyone got experience to fix it ? Thanks very much
GaryHi Gary
"Gary" wrote:

> Dear All
> I have try to detach and re-attach database from SQL7.0 (Production Server
).
> The detach process was success, but re-attach database occur a error. Ther
e
> is a Error message show on my screen.
> ----
--
> Changed Language setting to us_english.
> Server: Msg 3624, Level 20, State 1, Line 1
> Location: pageref.cpp:3882
> Expression: pPage->GetLsn () == lp -> GetPrevPageLsn ()
> SPID: 9
> Process ID: 148
> Connection Broken
> ----
--
> Do anyone got experience to fix it ? Thanks very much
I have not seen the error, but you may want to try renaming the log file and
using sp_attach_single_file_db. I would also check that this disc if fine
(CHKDSK or similar) and that no errors are being reported in the System Even
t
log.

> Gary
>
John

No comments:

Post a Comment