SQL Agent will not start
Date: Tue, 27 Apr 2004 16:02:02 -0700
Hello,
Has anyone seen this error I am receiving when I try to
start SQL Agent.
[000] SQLServerAgent cannot start because the msdb
database is not available for normal access.
How can I make MSDB available again. MSDB doesn't show
that it is in suspect or emergency mode. I can't find
info on this anywhere.
Thanks in advance.
Relevant Pages
- Re: Cant Install SP4 for SQL 2000 / Win2k3
... This explains why a reinstall did not fix the errors. ... ran 'sp_resetstatus msdb' from query analyzer, ... > The LSN %S_LSN passed to log scan in database '%.*ls' is invalid. ... > To resolve this problem, obtain the latest service pack for Microsoft SQL ...
(microsoft.public.sqlserver.setup) - Re: Cant Install SP4 for SQL 2000 / Win2k3
... Looks like your msdb database has been marked as suspect. ... > See the SQL Server errorlog for more information." ...
(microsoft.public.sqlserver.setup) - Re: MSDB (Subspect)
... I have one more suggestion to this issue, I feel that during the MSDB mdf ... and LDF physical file copy (cold Backup), they would have started the SQL ... Stop & Start the SQL Server ... > Probably because the database was damaged when you took the backup. ...
(microsoft.public.sqlserver.server) - Re: Cant Install SP4 for SQL 2000 / Win2k3
... Shouldn't unstalling and reinstalling SQL2000 result in a pristine msdb ... > Looks like your msdb database has been marked as suspect. ...
(microsoft.public.sqlserver.setup) - Re: Can I restore msdb from another sqlserver s backup
... Tibor Karaszi, SQL Server MVP ... "Karin W" wrote in message ... > We have the same problem with a suspected MSDB. ... > droped because it'a a system database. ...
(microsoft.public.sqlserver.server) |
|
