Showing posts with label Database Suspect. Show all posts
Showing posts with label Database Suspect. Show all posts

Tuesday, April 9, 2019

Database Suspect হলে এই টা চালাতে হবে।

EXEC sp_resetstatus [POSX];
ALTER DATABASE [POSX] SET EMERGENCY
DBCC checkdb([POSX])
ALTER DATABASE [POSX] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([POSX], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [POSX] SET MULTI_USER