the database log file is full that database configure in logshipping, what is the solution?

All Replies

• Tuesday, May 01, 2012 11:13 PM

  Moderator

   

   
  

  0

  Here are possible alternatives

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

  ---

  Regards,
  Ahmed Ibrahim
  SQL Server Setup Team
  This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
  This can be beneficial to other community members reading the thread.

  • Proposed As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Wednesday, May 02, 2012 2:51 AM
  •  
  • Reply
  • Quote

   
• Wednesday, May 02, 2012 12:58 AM

  Moderator

   

   
  

  1

  Hello,
  
  If the reserved space of logs is getting full then the log shipping scheme is not working as expected, transaction log backups are not successful  and are not truncating the inactive portion of the logs as part of log shipping operations.
  
  Make sure the service accounts of both servers have access to the shared folder (UNC path).

  The following resources may help you:
  
  http://msdn.microsoft.com/en-us/library/ms190640.aspx
  
  http://msdn.microsoft.com/en-us/library/ms190224.aspx
  
  Hope this helps.

  Regards,
  
  Alberto Morillo
  SQLCoffee.com

  • Edited by Alberto MorilloMVP, Moderator Wednesday, May 02, 2012 1:11 AM
  • Proposed As Answer by BalmukundMicrosoft Employee, Moderator Wednesday, May 02, 2012 2:00 AM
  • Marked As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Thursday, May 03, 2012 8:03 PM
  •  
  • Reply
  • Quote

   
• Wednesday, May 02, 2012 2:01 AM

  Moderator

   

   
  

  0
  Unless there are some heavy work done in single transaction, I don't expect log usage to increase and become full if t-log backups are scheduled.
  
  As Alberto said, check if backup log job is really working as expected.

  ---

  Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
  --------------------------------------------------------------------------------
  This posting is provided "AS IS" with no warranties, and confers no rights.
  --------------------------------------------------------------------------------
  My Blog | Team Blog | @Twitter

  • Proposed As Answer by Alberto MorilloMVP, Moderator Wednesday, May 02, 2012 2:59 AM
  • Marked As Answer by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Thursday, May 03, 2012 8:03 PM
  •  
  • Reply
  • Quote