Database in Suspect Mode reasons:
1. When records are inserted (it could be bulk inserts through Stored Procedure) in Application Database from application web form, if power failure on the Database Server Machine occurs during at that time , will there be chances of data corruption for those specific database records.
2. When records are inserted (it could be bulk inserts through Stored Procedure) in Application Database from application web form, if someone stops the SQL SERVER Database Engine Service, will there be chances of data corruption for those specific database records.
3. When the data files are not available.
Solution:
1. Restore the database backup file.
2. If no backup is available, then run the following commands
ALTER DATABASE Databasename SET EMERGENCY
DBCC CHECKDB 'Databasename'
ALTER DATABASE Databasename SET SINGLE USER with ROLLBACK IMMEDIATE
DBCC CHECKDB 'Databasename, REPAIR_ALLOW_DATA_LOSS'
ALTER DATABASE Databasename SET MULTIUSER
1. When records are inserted (it could be bulk inserts through Stored Procedure) in Application Database from application web form, if power failure on the Database Server Machine occurs during at that time , will there be chances of data corruption for those specific database records.
2. When records are inserted (it could be bulk inserts through Stored Procedure) in Application Database from application web form, if someone stops the SQL SERVER Database Engine Service, will there be chances of data corruption for those specific database records.
3. When the data files are not available.
Solution:
1. Restore the database backup file.
2. If no backup is available, then run the following commands
ALTER DATABASE Databasename SET EMERGENCY
DBCC CHECKDB 'Databasename'
ALTER DATABASE Databasename SET SINGLE USER with ROLLBACK IMMEDIATE
DBCC CHECKDB 'Databasename, REPAIR_ALLOW_DATA_LOSS'
ALTER DATABASE Databasename SET MULTIUSER
If you are unable to repair database from suspect mode then you can use third party tool which can help you to easily repair and recover database from suspect mode. Read more: http://www.sqlrecoverysoftware.net/blog/repair-database-from-suspect-mode.html
ReplyDelete