Full Recovery will take care t-logs?

• jenniferhu46

  SSCrazy

  Points: 2990

  More actions

  September 22, 2003 at 2:23 pm

  #151932

  Hi,

  We are in SQL Server 2000 and we just changed our databases to full recovery model last month and expect the full recovery will include t-logs backup and truncate the t-log automatically.

  However, the t-log is keep growing and the last successful full backup was 2 days ago but didn't reduce the log size.

  Can someone tell me what we might do wrong and what we should do now.

  Thank you.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  September 22, 2003 at 3:12 pm

  #475319

  You still should to run log backups. The log potentially has virtual log files that are not empty and cannot be deleted.

  You can use this script to shrink the log

  http://www.sqlservercentral.com/scripts/contributions/26.asp

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net