Information about last shrinking operation performed

[MeatLoaf]

I can't find any Database Maintenance Plan or individual SQL agent job that is explicitly shrinking it so I'm not sure how to find out when it has happened.

Is there a system table or view that I could use to find out when the last shrink operation on transaction log was done?

So I can I check the last time a shrink operation was done on a SQL Server 2000 transaction log ?

[Anil]

Hello Patrick

You should be able to determine this from the "last modified" time on the "ldf" file (unless it has autogrown in the interim - which seems unlikely as it is still only 1MB)
Does the database have logged activity happening? (make sure)
Is the autoshrink database option turned on? (You wouldn't see a SQL agent job if that was the case a background task performs these shrink operations). This setting is extremely unrecommended
You can also go for Microsoft support for shrinking database

https://msdn.microsoft.com/en-us/library/ms189080(v=sql.105).aspx

https://support.microsoft.com/en-us/kb/307487

keep updating us

Thanks

Anil