Maintain Transcriptional Log File

• surma.sql

  SSCommitted

  Points: 1552

  More actions

  April 11, 2012 at 12:59 pm

  #272125

  Hello Friends,

  I need to Maintain Transcriptional Log File on Different server.

  I know some certain ways but dont know which one is the best.

  either use dbcc shrink command

  or

  create maintenance plan and schedule.

  so I need to maintain Transcriptional Log File because it keep growing and need to maintain.

  please give me best of best solution to handle this situation

  Thanks

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 11, 2012 at 1:02 pm

  #1472170

  You should probably read this: http://www.sqlservercentral.com/articles/Administration/64582/.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 11, 2012 at 1:02 pm

  #1472169

  Please read through this - Managing Transaction Logs[/url]

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Grant Fritchey

  SSC Guru

  Points: 398882

  More actions

  April 12, 2012 at 4:36 am

  #1472453

  And just to reinforce what the others have said, read this blog post[/url].

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning