I've experience a power failure that makes my database a suspect and unusable. So what I did was to detach the suspect database and then reattach it. However, when attaching the said database using sp_attach_db, I've encountered an error like this:
-------------------------------------------
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:3882
Expression: pPage->GetLsn()==lp->GetPrevPageLsn()
SPID: 8
Process ID: 720
[Microsoft][ODBC SQL Server] Communication link failure
Connection broken
-------------------------------------------
I think the database may be damage or may be something happened when it encountered a power failure. Anyway, I have a backup of the said the database, but it's almost a month old already, so I'm very desperate in recovering that database. Also, I'm using MS SQL 7.
If anyone have any idea/answer to what should I do, please post. Thank you.
-------------------------------------------
Server: Msg 3624, Level 20, State 1, Line 1
Location: pageref.cpp:3882
Expression: pPage->GetLsn()==lp->GetPrevPageLsn()
SPID: 8
Process ID: 720
[Microsoft][ODBC SQL Server] Communication link failure
Connection broken
-------------------------------------------
I think the database may be damage or may be something happened when it encountered a power failure. Anyway, I have a backup of the said the database, but it's almost a month old already, so I'm very desperate in recovering that database. Also, I'm using MS SQL 7.
If anyone have any idea/answer to what should I do, please post. Thank you.