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 Lie

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

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
>