- hacer new query en master.

- alter database dbname set emergency

- ALTER DATABASE DBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

- dbcc checkdb ('dbname', repair_allow_data_loss)

- alter database dbname set multi_user

saludos