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
Gary
Hi 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. 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
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 Event
log.
> Gary
>
John
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment