John Rowan (6/19/2008)
Jeff, Do you have documentation to support that SQL Server behaves that way? I've never heard this before. Are you saying that if you create a new DB and set it to FULL recovery mode, that SQL Server will not 'act' as if it is in FULL mode until you take a backup? Again, I would like to see the resource where you learned this.
Interestingly enough - it looks like 2000 and 2005 behave differently on this. I just ran a test (build a DB, and then create a table, insert some data, delete table, repeat from create table one x 50), and the 2005 log keeps growing, whereas the 2000 does not.
Again - it's not documentation by any means, but it sounds Jeffrey is onto something.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?