SQL database is marked suspect

Sometimes, during MS SQL Server installation, SQL agent fails to start and the msdb SQL database is marked suspect. This article provides solution to MS SQL Server database’ suspected state.
Actually, msdb database is a database used by SQL Server Agent for scheduling alerts and jobs and maintaining Database Mail. The suspect error in SQL database occurs when a user tries to connect to the SQL database and opens SQL Server Management Studio (SSMS). But to his surprise, he encounters an intimidating error message saying:
“Database ‘msdb’ cannot be opened. It has been marked suspect”
Simple reason behind this suspected error message is the suspected behavior of SQL database. That is SQL Server sets the database to suspect status when some database files are missing or files are somehow corrupted. This suspected situation is also attributed to any one of the following true conditions.
The error log file does not match with the database file
Corruption in SQL database .MDF file
Moreover, following error log is generated when SQL database is marked suspect at the time of SSMS start-up:
“The log scan number (152:284:1) passed to log scan in database ‘msdb’ is not valid. This error may indicate data corruption in mdf database or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.”
This error clearly indicates that any kind of corruption in SSMS results in inaccessibility of SQL database components and various error messages.
There is a solution to this. You can reset the status of the database with sp_resetstatus procedure. sp_resetstatus is an inbuilt utility of SQL Server that resets the SQL database status and allows user to access the SQL database again.
What if this inbuilt utility fails to resolve the issue correctly? Well, at that time you can use SQL Recovery tool to resolve the above suspect error and to access the database without any hassle. Repair SQL Server tool provides complete, accurate and successful recovery of data from corrupt SQL database. All SQL Server database components such as triggers, tables, views, stored procedures, rules, user functions, etc. are recovered easily using the software. It supports SQL Server 2000 and 2005.