Can I know, who and when changed size of database transation log?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Jan 31 '13 at 10:04
This question came from our site for professional and enthusiast programmers.
No. Point. This stuff is not tracked in SQL Server.
You can possibly see when (there is an event log that is available via standard reports) and see if it it was someone or auto growth (as per settings), but if it was a user, no - it is not tracked who issued the command.
That is pretty much never needed in any professional setup. You know, where you do not have clueless people do random changes. In a professional setup you have change tickets first, so you can see when a change was planned, implemented.
Most likely you did. Most cases database files, including transaction log, are configured for auto-growth. Auth-growth enables the file to increase its size as needed, any time is needed. The trigger for growth can be any activity that requires log space. The activity that triggered the growth is most cases ordinary, normal activity. The true problem is why is the log growing. Most times is simply lack of log truncation, see Factors That Can Delay Log Truncation. Other time it can be a single event that generates a lot of log and requires growth. But most often is just bad maintenance (lack of truncation).
To shrink the log now, see How to Shrink the SQL Server log.
If the log was explicitly increased in size, the event is likely captured in the default administrative trace.