Database crashed its very urgent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Srihari - 03 Oct 2005 11:03 GMT

Hi All,

one of my database is suddenly crashed with power fluctuation and when i
started the server it is showing "not able to connect database". I have taken
backup and i was trying to attach database in other system. It has given me
the following error.

---------------------------
Microsoft SQL-DMO (ODBC SQLState: HY000)
---------------------------
Error 9003: The LSN (375:9588:1) passed to log scan in database
'QVLMSCASPARES' is invalid.
---------------------------
OK
---------------------------

Please any one can help me out.

With Regards,
AHARI

Reply to this Message

Sue Hoegemeier - 03 Oct 2005 12:53 GMT

You should use sp_detach_db to explicitly detach the files,
copy then and then try attaching on another system. You also
need to make sure you have all files from the original
database.
However, if your original database is corrupted you
shouldn't be using sp_detach/sp_attach. You should check all
logs and determine the cause of the corruption and address
that issue. Often you need to restore from your last known
good backup.

-Sue

>Hi All,
>
[quoted text clipped - 16 lines]
>With Regards,
>AHARI

Reply to this Message