Google

Tuesday, November 29, 2011

MSSQL ERROR: SQL Server Alert System: 'Demo: Sev. 24 Errors' occurred on \\DatabaseName

ALTER DATABASE DatabaseName
SET single_user WITH ROLLBACK IMMEDIATE;
go
DBCC checkdb ('DatabaseName', repair_allow_data_loss);
go


DBCC CHECKDB

ALTER DATABASE DatabaseName
SET MULTI_USER
GO

No comments:

Post a Comment