Information about last shrinking operation performed 1889
See How We Help you Protect your Data, Detect and React to Threats Watch Now
Login to Your Account
Untitled Document
+ Reply to Thread
Results 1 to 2 of 2

Thread: Information about last shrinking operation performed

  1. #1
    Junior Member
    Join Date
    Jan 2013

    Information about last shrinking operation performed

    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 ?

  2. #2
    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

    keep updating us



+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts