Home Forums SQL Server 7,2000 Performance Tuning How to reset performance counter SQL Server:Databases - Log growths RE: How to reset performance counter SQL Server:Databases - Log growths

  • 1) 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 this

    Restarting/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...