title: The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
body: <p>I am getting following error while I am trying to delete 355447 records in single delete query.</p>
  
  <p>The transaction log for database is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases</p>
  
  <p>I tried foll. solution, But still delete statement throwing same error.</p>
  
  <pre><code>DBCC SHRINKFILE(DBname_Log, 2)
  BACKUP LOG gis_sync WITH TRUNCATE_ONLY
  DBCC SHRINKFILE(DBname_Log, 2)
  </code></pre>
  
  <p>Please help me to solve....
  Thanks</p>