The transaction log for the database "Name" is full. To find out why log space cannot be reused, see the log_reuse_wait_desc Column in sys.databases

Question

I am getting the following error while I try to insert 8355447 records in one query.i insert using sql-server-2008-r2.

INSERT to table

select * from [DbName] .table

Please help me decide .... Thanks

Answer 1

Check the disk space on SQL Server, as it usually happens when the transaction log cannot expand due to lack of free disk space.

, , TEMPDB.

Answer 2

, . , - .

Answer 3

. - , Stackoverflow .

• . , say 'n' no. , "n" ..
• , .
• , , .

• , SQL TRUNCATE_ONLY ( , ).
  dbcc sqlperf ('logspace') .

  , : -  dbcc shrinkfile (, TRUNCATEONLY)

  DBCC Shrinkfile DBCC Shrinkfile.

• If you do not get space even after this, you may need to carefully shrink it by redistributing the pages in the database (indicating the target size), details about this can be taken from the provided link.