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
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
No comments:
Post a Comment