November 25, 2008 at 3:59 pm
after restoring master db.the temp db went disable state.how to i bringit back to enable state
November 25, 2008 at 4:27 pm
Do you mean that it is stopped? If so, then you can restart it by right-clicking on the "SQL Server Agent" icon and selecting "Start"
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 25, 2008 at 6:57 pm
after restarting the agent also it is in disable state.i done it but no use.
November 25, 2008 at 8:06 pm
What do you mean by "disable state"?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
November 25, 2008 at 8:30 pm
sqlserver agent (disabled......).like that at sql server agent in the management studio.i restarted the agent also.
November 25, 2008 at 9:42 pm
mohinidba (11/25/2008)
after restoring master db.the temp db went disable state.how to i bringit back to enable state
right click on the Agent and select Start, and still if does not work, login with sa and repeat the same. it will start
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
February 17, 2009 at 3:15 am
Do you get this message in SQL Server log?
Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
Try to run the statement RECONFIGURE and then you will be able to start the agent.
Håkan Winther
Senior Development DBA
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply