Error 926 In Sql Server 2005
Contents |
additional information might be available elsewhere. Thank you for searching on this message; your search helps us identify those msdb suspect sql 2000 areas for which we need to provide more information. If the product or version you are looking for is not listed, you can use this search box to search TechNet, the Microsoft Knowledge Base, and TechNet Blogs for more information. Enter the product name, event source, and event ID. For example: Vista Application Error 1001.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings
Option 'emergency' Cannot Be Set In Database 'msdb'
and policies of this site About Us Learn more about Stack Overflow warning: you must recover this database prior to access. the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation
Database 'msdb' Cannot Be Opened Due To Inaccessible Files Or Insufficient Memory
Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL+Server&ProdVer=9.0&EvtID=926&EvtSrc=MSSQLServer it only takes a minute: Sign up Database MSDB can not be opened up vote 9 down vote favorite 2 I have got this problem in local instance of SQL Server 2008 R2 on my machine. There are several databases on this instance. But I am not able to see any of them from the object explorer. I am able http://stackoverflow.com/questions/16229415/database-msdb-can-not-be-opened to query my databases from the new query window. But not able to see any of them. Whenever I try to explore the databases I get this error : Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926). I have tried Refreshing the connection Reconnecting the connection Restarting the service Sql Server (MSSQLSERVER). Restarting the SQL Server Management Studio Restarting my machine I have also tried combinations of above, but nothing works. My operating system is Windows 7 Ultimate (64 bit). SQL Server Management Studio Version is 10.50.2500.0. sql-server-2008-r2 ssms share|improve this question asked Apr 26 '13 at 5:36 Devraj Gadhavi 1,79931739 add a comment| 2 Answers 2 active oldest votes up vote 9 down vote accepted I found my answer in this link. EDIT : Including both the solutions from link because of possible Linkrot in future. Login with sa account, for both the solutions. Solution 1 Open new query window EXEC sp_resetstatus 'DB_Name'; (Explanation :sp_resetstatus turns off the suspect fl
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or http://dba.stackexchange.com/questions/35379/database-msdb-cannot-be-opened-it-has-been-marked-suspect-by-recovery-2008-er posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top database 'msdb' cannot be opened. it has been marked suspect sql server by recovery 2008 error code 926 up vote 1 down vote favorite 1 I m using SQL server 2008, i got suddenly today an error while i was accessing database from visual studio the error is database 'msdb' cannot be opened. it has been marked suspect by recovery 2008 error code 926 don't know what to do to get out from this type of error. any one have any idea please let me know thanks yagnesh sql-server-2008 share|improve this question asked Feb sql server 2008 25 '13 at 12:47 Yug 108113 migrated from stackoverflow.com Feb 25 '13 at 15:39 This question came from our site for professional and enthusiast programmers. 1 Eek. Can you dig through the SQL Server Error Log, and the Windows Event Log, and see if there are any indications of what happened? e.g. storage hardware failure of some sort? The safest way out of this will likely be restoring a backup of msdb, but you might get lucky and just have a corrupt nonclustered index or something. –db2 Feb 25 '13 at 15:44 Welcome to dba.se, Yug. This existing question may help: dba.stackexchange.com/questions/28446/… –JHFB Feb 25 '13 at 15:49 you can try to use sp_resetstatus 'msdb' –user20553 Feb 25 '13 at 16:08 1 As @db2 said, check your error logs for details on why it was marked suspect. There should be more details in there. Additionally, you can try and run a DBCC CHECKDB to get more information. –Mike Fal Feb 25 '13 at 16:32 Any chance you have a recent backup that you can restore? MSDB has information on backups, jobs, dts and ssis etc so it's not like it changes on a minute by minute basis (at least hopefully not). So with any luck a backup from last night should work. –Kenneth Fisher Feb 25 '13 at 17:12 | show 1 more comment 1 Answer 1 active oldest votes up vote 1 down vote accepted The