BUCKBERG
asked on
sql transaction log has not been updated for 30 days
We have a SQL database that the last update date to the transaction log is 30 days ago. it is set to autogrow and is no where near full size. Actually, it is quite small compared to the database. we have had no performance issues but this concerns me. I am at a loss to how this can happen.
Thank you,
Thank you,
Are you going by the directory "last updated" date? That is not necessarily accurate for SQL Server files. SQL doesn't update the date every time it writes (good thing, as the overhead of that would be enormous).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unfortunately, for the database the backup mode is "Copy Only". I would suspect since there is no checkpoint that the transaction log would grow large, which is the experience I have with another instance at our sister site. The log file is tiny compared to database. I will have to check if the recovery mode is simple. I am looking for another explanation.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.