LOG TRUNCATION AND DBCC SHRINKFILE

• Subhash-63067

  SSCarpal Tunnel

  Points: 4171

  More actions

  February 22, 2005 at 8:57 am

  #87723

  HAI,

  Every Weekend we used to do Log Truncation and DBCC Shrinkfile (if required) on all databases.

  I just want to know that, is there any system table which used to track all these operations (like all backup operations are logged in system tables like backupset,backumediaset etc...)

  Please comment

  
  subban

• peterhe

  SSChampion

  Points: 11469

  More actions

  February 23, 2005 at 6:57 am

  #543677

  When you truncate log, it's logged in the SQL server ErrorLog file.

  You can also get the information in master..sysperfinfo.

  Object_name: SQLServeratabases

  Counter: Log Truncations and Log Shrinks  

  Instance name: the database name you are monitoring.

  You can set up a job to capture these events. The table does not keep historical data, it only keeps the current value.