Database Suspect

This question has suggested answer(s)

Ax Database Suspect.

Please let me know if any setup must be done to improve this situations.

Best regards,

Akhtar Hussain

All Replies
  • Nope

  • Try the steps mentioned here:

    www.karaszi.com/.../info_corrupt_suspect_db.asp

    You most likely need a DBA to help you recover the database and get it back to the correct state.

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

  • I found a query for Suspected Database.

    Use that query...

    EXEC sp_resetstatus 'Database Name';

    ALTER DATABASE Databas Name SET EMERGENCY

    DBCC checkdb('Database Name')

    ALTER DATABASE Database Name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CheckDB ('Database Name', REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE Database Name SET MULTI_USER

    This query is work 100%

    Regards;

    Akhtar Hussain

  • I found a query for Suspected Database.

    Use that query...

    EXEC sp_resetstatus 'Database Name';

    ALTER DATABASE Databas Name SET EMERGENCY

    DBCC checkdb('Database Name')

    ALTER DATABASE Database Name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    DBCC CheckDB ('Database Name', REPAIR_ALLOW_DATA_LOSS)

    ALTER DATABASE Database Name SET MULTI_USER

    This query is work 100%

    Regards;

    Akhtar Hussain