Error Database MS SQL Server

Error status : In Recovery

ALTER DATABASE NAMA_DB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB ('NAMA_DB', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE NAMA_DB SET MULTI_USER

Error status : Restoring

USE [master]

Error status : Suspect

EXEC sp_resetstatus NAMA_DB;
ALTER DATABASE NAMA_DB SET EMERGENCY
DBCC checkdb(NAMA_DB)
ALTER DATABASE NAMA_DB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (NAMA_DB, REPAIR_ALLOW_DATA_LOSS)

Setelah script diatas berhasil, set kembali ke multi user

ALTER DATABASE HakaERP SET MULTI_USER