{"id":389,"date":"2012-08-25T08:48:13","date_gmt":"2012-08-25T08:48:13","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=389"},"modified":"2019-10-05T11:48:50","modified_gmt":"2019-10-05T06:18:50","slug":"database-msdb-cannot-be-opened-it-has-been-marked-suspect-by-recovery-see-the-sql-server-error-log-for-more-information","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/database-msdb-cannot-be-opened-it-has-been-marked-suspect-by-recovery-see-the-sql-server-error-log-for-more-information\/","title":{"rendered":"Database \u2018msdb\u2019 cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information."},"content":{"rendered":"

Error:<\/strong><\/p>\n

Database \u2018msdb\u2019 cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information.<\/p>\n

Error Message:<\/strong><\/p>\n

\"\"<\/a><\/p>\n

Causes:<\/strong><\/p>\n

The main cause of the above error message is that the SQL database has been marked suspected<\/strong>. This situation occurs under following conditions:<\/p>\n

    \n
  1. When the ldf file does not match with the mdf file.<\/li>\n
  2. Database might be corrupted.<\/li>\n
  3. Database \u2018msdb\u2019 cannot be opened due to insufficient permission or\u00a0inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.<\/li>\n
  4. User does not have permission to alter database \u2018msdb\u2019, the database does not exist, or the database is not in a state that allows access checks.<\/li>\n<\/ol>\n

    Workaround 1:<\/strong><\/p>\n

    If MSDB data base is found corrupt, we can replace it from backup.<\/p>\n

    For example<\/p>\n

    MSDB mdf and ldf files will be located in DATA folder of SQL, we can find backup in template data folder.
    \nNote :- Perform this workaround if you are sure about the exact location of the msdb data base\u00a0 & before replacing\u00a0 it from backup rename the corrupted file.<\/p>\n

    Workaround 2:<\/strong><\/p>\n

    Remove Microsoft SQL Server 2005 completely from Control panel<\/p>\n

    Control Panel | Add or Remove Programs | Microsoft SQL Server 2005<\/p>\n

    In the first dialog, make sure to select the “RELYONDB: Database Engine” radio button.<\/p>\n

    If RELYONDB is the only instance, then select all check boxes & Click Next and Finish to proceed with the uninstall.<\/p>\n

    If there is no other SQL instance, I would go on to clean out all SQL components with the following steps.<\/p>\n

    Uninstall Microsoft SQL Server Native client<\/p>\n

    Uninstall Microsoft SQL Server Setup support files<\/p>\n

    Uninstall Microsoft SQL Server VSS writer<\/p>\n

    Re-install SQL Server 2005 RELYONDB and attach the data files from application.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Error: Database \u2018msdb\u2019 cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information. Error Message: Causes: The main cause of the above error message is that the SQL database has been marked suspected. This situation occurs under following conditions: When the ldf file does not match […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/389"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=389"}],"version-history":[{"count":1,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/389\/revisions"}],"predecessor-version":[{"id":2494,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/389\/revisions\/2494"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=389"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}