log file modified date does not change

Hi ,
I would like to check if the modified date of the log file be changed only
if there's not enough allocated disk space for the txn log and SQL needs to
expand it ?
This is because i have set a full recovery and doing full database & txn
log backup every nite since 2 days ago and it seems that the file size has
been stable and the modified data did not change either
appreciate ur advise
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200511/1
I don't think the modified date is a good indicia to look at. You can set up
performance monitor alerts to alert you about file growth.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:57dd7904ff6e4@.uwe...
> Hi ,
> I would like to check if the modified date of the log file be changed
> only
> if there's not enough allocated disk space for the txn log and SQL needs
> to
> expand it ?
> This is because i have set a full recovery and doing full database & txn
> log backup every nite since 2 days ago and it seems that the file size has
> been stable and the modified data did not change either
> appreciate ur advise
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200511/1
sql