Post reply

Fixing database marked as SUSPECT

  • July 30, 2007 at 6:05 am

    #179916

    Hi,

    My laptop hanged as I was running a large table update and when I restarted my database was marked as 'SUSPECT'.

    Running sp_resetstatus @dbname = "mydb" says that the flag has allready been reset but does not make any diffference.

    When I try

    SP_CONFIGURE 'allow updates', 1

    RECONFIGURE WITH OVERRIDE

    GO

    UPDATE master..sysdatabases set status = -32768 WHERE name = 'mydb'

    GO

    SP_CONFIGURE 'allow updates', 0

    RECONFIGURE WITH OVERRIDE

    I get the error message

    Update or insert of view or function 'master..sysdatabases' failed because it contains a derived or constant field.

    Is there any other alternative to get into emergency mode to recover the data in the database?

     

    Rgds and Thx

    Christo

  • July 30, 2007 at 6:36 am

    #723272

    if it is a log corruption, you can rebuild the log. You will loose any transactions hanging around in it but will have most of your data back. Check google for DBCC REBUILD_LOG. There are many how to's

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply