Backup Failure

• vino5786

  Right there with Babe

  Points: 743

  More actions

  October 3, 2011 at 12:04 am

  #248875

  Hi friends,

  Here is an scenario, A database size 270 GB.DR is log shipping. Full backup is running using SQL Litespeed at 12:00 AM daily, Every Sunday Night @ 1:00 AM index defrag is running. And the backup is failing every Sunday night with the error "log is full cannot re-use"

  My question, is there any relation between taking full backup and log file becoming full.before running backup we running DBCC checks on the DB.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 3, 2011 at 12:14 am

  #1389292

  http://www.sqlservercentral.com/articles/Transaction+Log/72488/

  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

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 3, 2011 at 3:56 am

  #1389377

  Please go through following article.

  Factors That Can Delay Log Truncation:

  http://msdn.microsoft.com/en-us/library/ms345414.aspx

  Troubleshooting a Full Transaction Log (Error 9002):

  http://msdn.microsoft.com/en-us/library/ms175495.aspx