Information about last shrinking operation performed - Reply to Topic
Close
Login to Your Account

Reply to Thread

Post a reply to the thread: Information about last shrinking operation performed

Your Message

Click here to log in

What is the latest version of LepideAuditor we launched? (like: 15.2)

 

You may choose an icon for your message from this list

Additional Options

Topic Review (Newest First)

  • 02-26-2013, 10:00 AM
    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
  • 02-20-2013, 11:46 AM
    MeatLoaf

    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 ?

Posting Permissions

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