| Author |
Monitoring Log Files Size
|
|
| Robert Lie 2005-04-28, 3:23 am |
| Dear All,
Is there any method to monitor the size of log files in SQL Server 2000?
If yes how?
Thanks
Robert Lie
| |
| David Gugick 2005-04-28, 3:23 am |
| 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
| |
| Robert Lie 2005-04-28, 3:23 am |
| 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.
>
| |
| Chandra 2005-04-28, 3:23 am |
| 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:
>
>
| |
| JosephPruiett 2005-04-28, 9:23 am |
| 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 the
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
>
| |
| JosephPruiett 2005-04-28, 9:23 am |
| 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 the
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
>
|
|
|
|