A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » SQL Server 2008 recovery model
The database must be set up for simple recovery model..
You can check this with:
If it is not simple then update with:
|
To avoid the database transaction log from exploding during large inserts, batch the insert and checkpoint the db after each batch.