Transaction log file full in logshipping RRS feed

  • Question

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

All replies

  • Do you mean out of disk space?
    Best Regards, Uri Dimant SQL Server MVP
    Sunday, October 10, 2010 7:25 AM
  • Do you mean to say that your logfile has definite size and has reached that size ? When you restore your db for the first time before LS initiation , all the database properties are same at the secondary database as well( autogrow,collation etc etc) . See if you are running out of your log file space on the primary database.

    Thanks, Leks
    Monday, October 11, 2010 5:36 AM
  • In addition, LS is applying LOG files from Primary to Secondary , not modified rows as it Mirroring does...So if the log file is out of space take care on Primary server to reduce physical sizeof the log file

    Best Regards, Uri Dimant SQL Server MVP
    Monday, October 11, 2010 5:43 AM