DB Growth Time

  • Hi

    How to find what time the MDF & LDF file has grown automatically? MDF & LDF has been set to auto growth.

    Thanks

    Shuaib

  • I always look at the date/time of the files at the OS level. These are updated to the last time the SQL Server service was started, but after that they are only modified when the file grows.

    It may be logged somewhere as well, but as we very rarely stop/start our SQL Server machines I've never had to dig around to find it: I can always do a DIR or use Explorer to find the date/time of the files.

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

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