The database goes into suspect mode.
If the Database is setup in Full mode of recovery and there is no Log Backup.Atleast Please try to resolve with minimum data loss.
EXEC sp_resetstatus '<database>';
ALTER DATABASE <database> SET EMERGENCY
DBCC checkdb('<database>')
ALTER DATABASE marcus8 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ('<database>', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE <database> SET MULTI_USER
No comments:
Post a Comment