How to find change in database size

  • I have a database whose size was 15 GB before and today I found someone changed it to 20 GB. Is there a way that I can find when it was changed and by whom? Or if I could set up some trigger on the system table that holds these changes? Your help will be greatly appreciated.

    Thank you for your help in advance.

  • It will be a little difficult since the user is "sa" 90% of the time (or the db owner if not SA) You should be able to review the logs and see what time the expansion occurred. Are you feeling this is a specific request by an operator rather than a normal expansion due to the automatic expansion processes?

    Guarddata-

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply