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
 General SQL Server Forums
 New to SQL Server Administration
 LDF is not being updated, normal ?

Author  Topic 

velnias2010
Posting Yak Master

125 Posts

Posted - 2011-07-06 : 04:37:54
Im having an issue with a site which has gone very slow, so just checking database etc.

So at the moment my

MDF File is 320MB and
LDF File is 18 MB

The one thing I noticed that was weird is that the LDF file hasnt been updated for 4 Days going by Date Modified when I know there has been DB transactions, just wondering if this should be possible ?

If not, how can I resolve it

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-07-06 : 05:36:21
The date modified is only set when SQL shuts down.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -