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

Question

I am getting following error while I am trying to insert 8355447 records in single insert query.i use sql-server-2008-r2.

INSERT INTO table

select * from [DbName].table

Please help me to solve.... Thanks

Answer 1

Check the disk space on the SQL Server as typically this occurs when the transaction log cannot expand due to a lack of free disk space.

If you are struggling for disk space, you can shrink the transaction logs of your application databases and also don't forget to shrink the transaction log of the TEMPDB database.