Question Status

Suggested Answer
Akhtar Hussain asked a question on 9 Jul 2013 8:56 PM

Ax Database Suspect.

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

Best regards,

Akhtar Hussain

Reply
Suggested Answer
Andreas Rudischhauser responded on 10 Jul 2013 2:53 AM

Nope

Reply
Suggested Answer
Tommy Skaue responded on 10 Jul 2013 4:07 PM

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

Reply
Akhtar Hussain responded on 16 Sep 2013 9:06 PM

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

Reply
Suggested Answer
Akhtar Hussain responded on 16 Sep 2013 9:08 PM

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

Reply
Suggested Answer
Andreas Rudischhauser responded on 10 Jul 2013 2:53 AM

Nope

Reply
Suggested Answer
Tommy Skaue responded on 10 Jul 2013 4:07 PM

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

Reply
Suggested Answer
Akhtar Hussain responded on 16 Sep 2013 9:08 PM

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

Reply