Monday, February 20, 2012

record server and agent start-up status

hi,
When the sql server and sql agent are first started, are
their status being written to any system tables or logs?
Many thanks.
JJThe SQL Server error log has the startup info for SQL
Server. The default location is the Log directory under your
SQL instance directory. The most recent file name is
errorlog. Previous logs have a number appended to the file
name.
The SQL Agent log has the startup info for SQL Server Agent.
It's also in the Log directory. File name is SQLAgent.Out
-Sue
On Mon, 13 Oct 2003 17:18:07 -0700, "JJ Wang"
<jwang@.leapwireless.com> wrote:
>hi,
>When the sql server and sql agent are first started, are
>their status being written to any system tables or logs?
>Many thanks.
>JJ

No comments:

Post a Comment