GilaMonster (10/15/2012)
Abu Dina (10/15/2012)
Bulk recovery - Bulk operations are minimally logged - other operations are logged as normal.But that's true for simple recovery as well.
I didn't know that. My understanding is that SIMPLE is the same as FULL except that SQL Server reclaims log space by itself and you can't do T-Log backups so no point in time recovery.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn