Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Catalunya, Spain
    Posts
    3

    Exclamation Unanswered: Please help (Sql server 2000) Critical Error

    Please any one can help me ?I have multiuser application ( VB 6.0 ) on SQL Server 2000 running.

    Last night my Sql Server was writting info on the Log file of one database when the power accidentally shut down. In fact, the server was executing one Microsoft Data Transformation Service ( DTS ) which transfers data from one table to another.

    This morning when the users tried to work with this database everything went wrong... I've not been able to attach MDF AND LDF files to SQL Server 2000 Desktop Engine.

    Looking for what happened I found those Info/Error LOG events:

    A)Starting up database 'pcserveis'.

    B)ex_raise2: Exception raised, major=34, minor=48, severity=21, attempting to create symptom dump
    C) "The transaction ( Process Id 5 ) was left in "interblockade" in Lock
    resources with another process and was chosen as subject of the "interblockade". Execute the transaction again." ( Sorry about wrong words , i'm using a translation tool from spanish )
    D) Could not undo log record (5019077:221:133), for transaction ID (0:15254626), on page (1:1917), database 'pcserveis' (database ID 11). Page information: LSN = (5019072:426:5), type = 1. Log information: OpCode = 2, context 1.. ( Error: 3448, Severity: 21, State: 1)
    E)Error while undoing logged operation in database 'pcserveis'. Error at log record ID (5019077:221:133).. (Error: 9004, Severity: 23, State: 7)

    F)An error occurred while processing the log for database 'pcserveis'..


    What can i do to restore my database? Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Please help (Sql server 2000) Critical Error

    You log file is toasted because of the power outage. Create a new log file and attach it to you database. But all transactions in th log file cannot be recovered. The other choice you have is to restore the database from the backup file and reprocess everything, assuming you have a good backup.

  3. #3
    Join Date
    Feb 2004
    Location
    Catalunya, Spain
    Posts
    3

    Thanks for your answer but...

    Obviously, this morning when the users noticed me the problem , i've restored last backup and they kept on working.

    My request was about if could be possible to repair the database more than a problem of losing data.

    Is there any solution or the only thing to do is to restore the last backUp?

  4. #4
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Thanks for your answer but...

    You will only lose the uncommitted data if you rebuild the log file. That is probably you best bet for not losing the data between the time the database crushed and the last backup run in this situation.

  5. #5
    Join Date
    Feb 2004
    Location
    Catalunya, Spain
    Posts
    3

    Thanks for your attention

    Thanks for your assistance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •