Forum Discussion

amutto's avatar
amutto
Level 4
8 years ago

DLO Data Base in "suspect" status.

Hi all,

Yesterday we have a unexpected power down on our DLO Server; then when the server go up back we realize that the DLO Console doen't open and the DLO database are in (suspect) state.

So, does anyone know how we can solve this issue? I found this query on the internet but I'm not sure if it could work.

ALTER DATABASE DLO SET EMERGENCY
DBCC checkdb(DLO)
ALTER DATABASE DLO SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (DLO, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE DLO SET MULTI_USER

 

Thanks,

Alex

  • Sorry, I could not wait and tried the above query.
    It worked correctly. 

    Thanks !

  • Sorry, I could not wait and tried the above query.
    It worked correctly. 

    Thanks !