SQL DATABASE ONARMA
ALTER DATABASE DBNAME SET EMERGENCY
go
ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
go
DBCC CHECKDB (DBNAME, REPAIR_ALLOW_DATA_LOSS);
go
ALTER DATABASE DBNAME SET MULTI_USER
go
ALTER DATABASE DBNAME SET ONLINE
ALTER DATABASE DBNAME SET EMERGENCY
go
ALTER DATABASE DBNAME SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
go
DBCC CHECKDB (DBNAME, REPAIR_ALLOW_DATA_LOSS);
go
ALTER DATABASE DBNAME SET MULTI_USER
go
ALTER DATABASE DBNAME SET ONLINE