Error status : In Recovery
1 2 3 |
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
1 2 3 |
USE [master] RESTORE DATABASE NAMA_DB WITH RECOVERY GO |
Error status : Suspect
1 2 3 4 5 |
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
1 |
ALTER DATABASE HakaERP SET MULTI_USER |
Was this helpful?
0 / 0