InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:03:50 GMT20http://www.sqlservercentral.com/Forums/Topic665595-65-1.aspxNot as far as I know, since, according to Books Online, this counter measures the "Total number of times the transaction log for the database has been expanded". I don't understand why you'd want to reset the counter, though - if you know how the value at the beginning of a period and at the end of a period, then you can calculate how many growths have occurred during the period.JohnMon, 09 Mar 2009 08:21:37 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic665595-65-1.aspx1) shrink the file -- Does not reduce this value 2) restarted the server -- Resets the value to 0 3) Detach the server -- Does not change the value 4) Offline the DB -- Did not try thisRestarting/Detaching/ Taking the database offline causes a down time. I would like to know if there is a way to bring this value without causing a downtime. Cheers...Sat, 07 Mar 2009 18:51:57 GMTMohammed Imran Alihttp://www.sqlservercentral.com/Forums/Topic665595-65-1.aspxwhat are the things u tried to bring this down...? 1) shrink the file? 2) restarted the server? 3) Detach the server? 4) Offline the DB?Wed, 04 Mar 2009 05:29:15 GMTvinurajrhttp://www.sqlservercentral.com/Forums/Topic665595-65-1.aspxHi,I have a value of 690 for the performance counter [i][b]"SQL Server:Databases - Log Growths"[/b][/i]. Also, the database has not grown much and the value is staying the same for over three days now. I want to bring this value down or reset it. Can any one suggest the way to accomplish this task?Cheers...Fri, 27 Feb 2009 04:24:39 GMTMohammed Imran Ali