• - 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