troubleshooting Question

SQL Server 2008 R2 Error 926

Avatar of Math Tec
Math TecFlag for United States of America asked on
Microsoft SQL ServerWindows OSMicrosoft SQL Server 2008Windows Server 2008SQL
13 Comments2 Solutions202 ViewsLast Modified:
Hi,
I have SQL 2008 cluster working under windows server 2008. SQL server agent has stop working and when I tried to login to SQL management studio. I got 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).

Does the server agent stopping cause this? I mean if server agent not working am I able to login to management studio or not?
How I can solve this issue?
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros