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
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