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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Incorrect Info from Alerts ?

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2002-04-26 : 18:36:59
Hello,
I set up an alert for net-send if my production DB log file percent log used crosses 60%. My Db size is 15 GB and Log file is 3 GB.
Strangely I get alert saying the log file size is over 60% even though it is not. Am I missing something here? What is percent log? Doesn't the alert mean that LDF is over 60% of MDF file?
Thanks,
Sarat

chadmat
The Chadinator

1974 Posts

Posted - 2002-04-27 : 03:47:10
Hi Sarat,

Actually, this means that 60% of the 3Gb is used. So when 1.8 GB of your log is used, you will get this alert.

-Chad

Go to Top of Page
   

- Advertisement -