Re: Please Help : SQLServerAgent cannot start

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 20:17:58 +0530

Hi,

Could you please check whethere the UserAccess for MSDB is set to
RESTRICTED_USER.

sp_helpdb msdb

see the status colun of the output. If it is RESTRICTED_USER then use the
below command

ALTER DATABASE msdb set MULTI_USER

After that try restarting SQLAGENT service

Thanks
Hari
MCDBA

"ahwak" <abchawk@hotmail.com> wrote in message
news:6edd01c4839c$c72f9e20$a401280a@phx.gbl...
> Hi, All,
> We got power failure at last midnight, SQL server 7.0
> rebooted after that but "SQLServerAgent cannot start
> because the msdb database is not available for normal
> access." I can see and access the MSDB database, also
> DBCC CHECKDB is ok. Form the log file, I know when the
> SQL server was rebooted but it cannot tell when we got
> power failure. It may be the time during Jobs to run to
> backup the database and failed because of power failure.
> I try to reboot server this morning and got same error
> message.
> Here is part of the info in the log file at the first
> reboot after power failure.
> ******
> 195 transactions rolled forward in database 'msdb' (4).
> 0 transactions rolled back in database 'msdb' (4).
> Recovery complete.
> *******
>
> So, What should I do to fix it? Any suggestions?
>
> Thanks and have a good one
>
> ahwak

Relevant Pages

  • Please Help : SQLServerAgent cannot start
    ... We got power failure at last midnight, ... I can see and access the MSDB database, ... I try to reboot server this morning and got same error ...
    (microsoft.public.sqlserver.server)
  • RE: why inconsistency errors on msdb again?
    ... you saw errors on msdb. ... Yes, just the msdb database. ... or hardware problems are most unlikely? ... negative impact on the SQL server? ...
    (microsoft.public.sqlserver.server)
  • Database is not starting up
    ... I was trying to move the MSDB and Model datafiles from one ... To move the MSDB database on SQL Server 2000, ... Stop and then restart SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: sql dont start after detach model and msdb
    ... detach the model and the msdb database at the same time (with trace flag ... service wont start anymore!!! ... knowledgebase article 224071, I does also with msdb, but then I though about ... safeing time and detach msdb and model in the same time. ...
    (microsoft.public.sqlserver.server)
  • Re: MSDB (Subspect)
    ... I have already tried restore the msdb database from the backup but don't know why still subspected..... ...
    (microsoft.public.sqlserver.server)