Wednesday, January 17, 2018

Change SQL DB from SUSPECT to NORMAL mode

ALTER DATABASE  MicrosoftDynamicsAX  SET  EMERGENCY

DBCC CHECKDB('MicrosoftDynamicsAX')

ALTER DATABASE MicrosoftDynamicsAX SET SINGLE_USER WITH ROLLBACK IMMEDIATE

--Take DB backup,,before running below script.

DBCC CHECKDB (MicrosoftDynamicsAX, REPAIR_ALLOW_DATA_LOSS)


ALTER DATABASE MicrosoftDynamicsAX SET MULTI_USER

No comments:

Post a Comment

Error readable from string in D365FO

 Reference class: RetailSyncOrdersSchedulerTask Error readable: private str generateHumanReadableErrorDetail(System.Exception _exception, st...