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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2011-12-27 : 08:03:39
|
| Hi Experts,As in one of my servers i found that Sql server agent is down i found nothing in error logs and in event logs. Please let me know what might be the root cause for this type of issues.Thanking you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-27 : 08:17:03
|
| did you try restarting it? is the startup type automatic?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2011-12-27 : 08:35:31
|
| Hi,yes i tried to restart from config manager and yes the startup is in automatice only. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-27 : 12:51:00
|
| wat happened when you tried? it got restarted?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-03 : 08:53:37
|
| Hi,Sorry for the late reply, yes it got started but i need to know RCA for this. i couldn't find any in the error logs nor in event viewer.Please let me know any thing about this..Thanking you. |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-01-03 : 09:38:40
|
| Hi Experts,Today I faced one more issue in one of my servers as one of my database was unavailable I took it to offline and again brought into online now its working fine. I tried to get the RCA but couldn't find any thing in Error logs and event logs now how to know what had happened to the db at that particular time.Please help me in this regards…Thank you In Advance |
|
|
|
|
|
|
Sql Agent Down