Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gk_sql
Starting Member
9 Posts |
 Posted - 2006-11-07 : 02:24:58
|
| Hi,In one of my production server i was not able to connect to MSDB database.Database was in suspect status and i ran the sp_resetstatus . Previously status in sysdatabase was 282. Now it come to 24. In EM it is showing as normaldatabase.But i was not able to view the jobs. When i tried to access tables in msdb it is not connecting.The error is "No operartions are allowed".Space is fine in the server. i dont have the backups also.I cant backup and restore the msdb becasuse i cant connect to msdb db now. IN EM the status is normal not in Suspect/Emergency Mode.Can anybody advice on this issue.Quick reply is appreciated.Thanks in advance.Gopigk |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-11-07 : 06:23:28
|
| Do you have an existing backup or not?-------Moo. :) |
 |
|
|
miranwar
Posting Yak Master
125 Posts |
Posted - 2006-11-07 : 14:27:26
|
| Have u tried detaching the DB? |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-11-07 : 21:37:06
|
| are you connecting via SA? who can access the db(under database properties\options\Access)--------------------keeping it simple... |
|
|
|
|
|
|
Immediate Help --- MSDB