Information about last shrinking operation performed 1889 https://lepide.com
Close
Login to Your Account
+ Reply to Thread
Results 1 to 2 of 2

Thread: Information about last shrinking operation performed

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    4

    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

    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

+ 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

Lepide® is a registered trademark of Lepide Software Private Limited. © Copyright 2018 Lepide Software Private Limited. All trademarks acknowledged.