Posts Tagged ‘backup’

Full transaction log on MSSQL

Sunday, January 17th, 2010
Had a big problem the other week when one of our databases was throwing heaps of exception email errors on scheduled tasks. After debugging for a few hours I worked out that the transaction log was completely full! Check out this useful article; http://msdn.microsoft.com/en-us/library/ms175495.aspx A useful tool is running the following command; backup log with no_log It's also suggested you do a Maintenance Plan Wizard - http://msdn.microsoft.com/en-us/library/ms189036.aspx I'll post more in this… Continue reading
  • Share/Bookmark