trowsell (11/14/2012)
Jason-299789 (11/14/2012)
If Logging isnt a priority on the Archive DB then set the recovery model to Simple.Even with it set to simple though as I try to run an INSERT INTO the log file just grows and grows whilst the transaction is in process and then clears down again when it is comlete.... I was wondering if this would still be the case if it was set to bulk-logged?
In bulk-logged the log will fill while the transaction is in process but will not be cleared afterwards until a log backup is run.
Hence you'll often have more log usage, not less.
Bulk-logged is for when you want minimal logging but also want to be able to restore the DB using log backups, so not just restore to the last full backup if there's a failure.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability