Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Can I know, who and when changed size of database transation log?

share|improve this question
add comment

migrated from stackoverflow.com Jan 31 '13 at 10:04

This question came from our site for professional and enthusiast programmers.

2 Answers

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.

share|improve this answer
add comment

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.

share|improve this answer
    
Here's an example of using the default trace to find out about log growth: strictlysql.blogspot.ca/2011/01/… –  Kevin Feb 2 '13 at 17:10
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.