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

Azure Function Apps

Content copied from AI. Azure Function Apps provide a serverless, event-driven compute service that lets you run code in languages like C#, ...