Ad

How To Temporarily Disable The Log In SQL2000/2005?

- 1 answer

Is there a way to stop the log file from growing (or at least from growing as much) in SQL2000/2005?

I am running a very extensive process with loads of inserts and the log is going through the roof.

EDIT: please note I am talking about an batch-import process not about everyday update of live-data.

Ad

Answer

Remember that setting the recovery mode to SIMPLE only allows you to recover the database to the point of your most recent backup. Pending transaction which have not been committed to the database - after the backup has been created - will be lost.

Ad
source: stackoverflow.com
Ad