Monitoring Log Files Size

Dear All,
Is there any method to monitor the size of log files in SQL Server 2000?
If yes how?
Thanks
Robert LieRobert Lie wrote:
> Dear All,
> Is there any method to monitor the size of log files in SQL Server
> 2000? If yes how?
> Thanks
> Robert Lie
You can use sp_helpfile to get a listing of all files (data and log) in
the current database.
David Gugick
Imceda Software
www.imceda.com|||Is there any way to send it the information to my email automatically?
David Gugick wrote:
> Robert Lie wrote:
>
>
> You can use sp_helpfile to get a listing of all files (data and log) in
> the current database.
>|||hi,
Yes. You can send the information to your e-mail address automatically.
For that you need to register your e-mail address in the SQL Server.
Create a scheduled job that executes sp_helpfile and sedn the result to
desired e-mail address
I believe this answers your question
thanks and regards
Chandra
"Robert Lie" wrote:

> Is there any way to send it the information to my email automatically?
>
> David Gugick wrote:
>|||Use SQL Agent Alerts to watch the Performance Monitor counters that track
file size, and when the log crosses a threshold that you define, SQL Server
Agent can take predetermined actions such as running a script to increase th
e
log size, sending you email, or shrinking the file.
"Robert Lie" wrote:

> Dear All,
> Is there any method to monitor the size of log files in SQL Server 2000?
> If yes how?
> Thanks
> Robert Lie
>|||Use SQL Agent Alerts to watch the Performance Monitor counters that track
file size, and when the log crosses a threshold that you define, SQL Server
Agent can take predetermined actions such as running a script to increase th
e
log size, sending you email, or shrinking the file.
Sorry I posted this answer on the other question you asked about log files.
"Robert Lie" wrote:

> Dear All,
> Is there any method to monitor the size of log files in SQL Server 2000?
> If yes how?
> Thanks
> Robert Lie
>