April 2, 2015 at 2:32 am
how to start the agent iam getting the below error :
April 2, 2015 at 2:33 am
getting the error:
SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is read-only).
April 2, 2015 at 2:38 am
Run the below command.
USE [master]
GO
ALTER DATABASE [msdb] SET READ_WRITE WITH NO_WAIT
GO
April 2, 2015 at 2:42 am
even I tried by running and starting the agent
but it also failed
April 2, 2015 at 2:47 am
Whats the error you got now??
April 2, 2015 at 2:58 am
no log in sql error log but in event vwr still showing the same error
SQLServerAgent could not be started (reason: SQLServerAgent cannot start because the msdb database is read-only).
April 2, 2015 at 4:31 am
Which edition are you on?
Is the msdb database corrupted?
Have you tried a DBCC CHECKDB to see if something comes up?
Do you see the database as readonly?
SELECT is_read_only
FROM sys.databases
WHERE name = 'msdb'
-- Gianluca Sartori
April 2, 2015 at 4:54 am
ran the cmd and showing the value is 0 .checked in sql agent log and found
SQLServerAgent cannot start because the msdb database is read-only
agent xp's are disabled and enabled to 1 and tried to restart the agent the xp's value back again to 0 .
April 2, 2015 at 6:14 am
My friend Gail Shaw suggested that the msdb data files could be read only in the file system. Make sure you check that as well.
-- Gianluca Sartori
April 2, 2015 at 6:37 am
I checked the msdb files they are not in readonly ..
April 2, 2015 at 6:40 am
observed sql agent service is not present in SSCM
April 2, 2015 at 6:54 am
Which edition please?
-- Gianluca Sartori
April 2, 2015 at 6:57 am
NO errors in MSDB after dbcc check and its an enterprise edition
April 2, 2015 at 7:04 am
Do you have the SQL Server Agent service in the services applet or is it missing from there as well?
-- Gianluca Sartori
April 2, 2015 at 7:07 am
agent service is there but when I tried to start prompting some services will stopped automatically
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply