How to fix MS SQL “Database 'msdb' cannot be opened. It has been marked suspect” error

Published by Jacob Martin on May 8, 2015

When MS SQL gets corrupted then users encounter several problems when accessing the database.  One of such problem is of ‘database suspected error’ which display Database ‘msdb’ cannot be opened. It has been marked suspect” error that results in severe threats to the SQL database users. Suspect error occurs when there is any corruption in SQL Server Management Studio (SSMS).

SSMS is the critical part of SQL Server and its main function is to manage, configure, develop and access all the SQL server components in a collaborative manner. Users have to first start the SQL Server Management Studio before you get to access the database queries, triggers, database tables, stored procedure, etc. But when it’s get damaged or corrupt, the entire SQL database such as queries, triggers, stored procedures tables, etc gets inaccessible.

So, when you try to connect to a SQL database by opening SSMS you receive the database suspect error that displays as follow:

“Database ‘msdb’ cannot be opened. It has been marked suspect“

With the above error, SQL Server stops working and it leave you baffled.

Thus, what has to be done in such situation of SQL database corruption? Well, at such situation you must take help of professional SQL Server file Repair Tool to fix the SQL database error and restore all the deleted databases components. However, before that let us know what  is the common causes behind this issues so that essential troubleshooting can be done.

Causes

Well the main causes behind the database suspected error’ which display Database ‘msdb’ cannot be opened. It has been marked suspect” error is:

• SQL database .MDF file is damaged or corrupt
• The error log file does not match with the database file

Solutions

1 – In case of mismatching of log file, user can use the inbuilt utility of SQL Server known as sp_resetstatus. With the use of this inbuilt utility user can change the SQL database status and access then they can access the SQL database.

2 – But in case the if error is occurring due to corruption, then it is recommended that you must use professional SQL Server Repair Tool to repair the SQL .mdf database file. With the help of this tool one can easily repair the severe corrupted or damaged MDF database file and that too within few minutes of time. This tool is specifically designed to fix and repairs the MS SQL error and corruption and retrieves the entire components such as triggers, stored procedures, views, rules, defaults, tables and records etc. The tool supports all three versions of MS SQL that is MS SQL 2000, 2005 and 2008. User can download the demo version absolutely free to analyze how the tool works and its reliability. Hence, repair MS SQL suspect error and recovers the entire database file with the help of MS SQL file repair tool.

Steps to fix MS SQL “Database ‘msdb’ cannot be opened. It has been marked suspect” error

Step 1: Stop the running MS SQL server. Perform the repair task on the copy of the corrupt database, click on the ‘OK’ button to continue.

Step 2: Click on the ‘Select database’ button and select the path of corrupt MDF file. You can also search your corrupt database file by using ‘Look in’ and ‘File Type’ button. click on the ‘Scan file‘ button to start the repairing process.

Step 3: The recoverable objects of database are listed in a tree view on the left side of the window. You can see the preview by clicking on the object.

Step 4: You can also search for a particular object by using ‘Find item’ option. Write the object name or a part of the object name in the given text box, check on ‘Match case‘ or ‘Match whole word‘ and then click find next button.

Step 5: Click on the ‘Start Repair’ icon. A dialog box will appear fill the SQL server instance name. To save the repaired file in the desired location click on the brows button and give the path, else the repaired file will be saved in the ‘Default SQL Location’. Click on the ‘OK’ button.

441 Total Views 1 Views Today