I have the following simple routine running once a week
TRUNCATE TABLE dbo.New_Business_Sales INSERT INTO dbo.New_Business_Sales SELECT * FROM [dbo].[vw_New_Business_Sales]
It fell over this week due to the error
The transaction log for database 'New Business' is full due to 'ACTIVE_TRANSACTION
This routine is quite intensive, I think there are several million records involved.
How do I get around the error? I have Googled and one piece of advice that kept cropping up was to insert the records 1000 at a time.....how would I achieve this?
Or, if anyone has any other suggestions, I'd be grateful.
Thank you as always.