none
log file full in log shipping RRS feed

  • Question

  • if the transaction log file full in log shipping on primary database what happened? How can i resolve that
    Friday, October 8, 2010 5:59 PM

All replies

  • Are you sure logshipping is working?
    Here is the article which has possible reasons of log becoming full.

    INF: Transaction Log Grows Unexpectedly or Becomes Full on SQL Server http://support.microsoft.com/?id=317375

    Please provide detailed information in your posts. Especially version and edition of SQL Server.


    Balmukund Lakhani | Please mark solved if I've answered your question
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, October 11, 2010 12:00 PM
    Moderator
  • I have asked you the same question in other thread --

    When you say your logfile is full , does that mean you have definite size for your logfile rather than unlimited growth(2tb) or your disk space is full ?


    I have seen you asking good basic questions in database mirroring forum for sometime now and it would be good if you can add more explanation ( more clarity on what you are trying to do)to your questions so that we can give you more appropriate solution or refer links.


    Thanks, Leks
    Monday, October 11, 2010 7:32 PM
    Answerer
  • I need interview purpose Mr.lekss, I want to change the job now. That's why i am aasking that question
    • Proposed as answer by rmd.jilan Wednesday, November 10, 2010 2:58 PM
    Wednesday, October 13, 2010 11:31 AM