June 19, 2008 at 11:46 am
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.
Unfortunately, I do not have a documented resource. I learned this last week at TechEd during a session with Paul Randall and Kimberly Tripp. I don't recall how the question came up, but Kimberly outlined this and it stuck (actually, surprised me and I've been meaning to test this myself).
Jeff
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
June 19, 2008 at 1:40 pm
From my earlier post:"Tlog is doing nothing as far as I can see -- apparently that's because there is no full backup and thus no possibility of tlog backups. The tlog file is 6GB containing only 64mb of data. "
It is set to a max size of 2 terrabytes with autogrowth on, but with only 64mb of 'active' data within a 6GB file it won't be growing anytime soon. I like to use the analogy of a five gallon gas can holding one gallon of gas to visualize sql server files.
June 19, 2008 at 1:42 pm
Indianrock (6/19/2008)
From my earlier post:"Tlog is doing nothing as far as I can see -- apparently that's because there is no full backup and thus no possibility of tlog backups. The tlog file is 6GB containing only 64mb of data. "It is set to a max size of 2 terrabytes with autogrowth on, but with only 64mb of 'active' data within a 6GB file it won't be growing anytime soon. I like to use the analogy of a five gallon gas can holding one gallon of gas to visualize sql server files.
Is that why you're not supposed to smoke in the server room?!? I always wondered! :hehe:
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 20, 2008 at 9:19 am
Unfortunately, I do not have a documented resource. I learned this last week at TechEd during a session with Paul Randall and Kimberly Tripp. I don't recall how the question came up, but Kimberly outlined this and it stuck (actually, surprised me and I've been meaning to test this myself).
Jeff
Thanks for the reply Jeff. It's always good to learn something that is undocumented. I was just curious as to where you got that from. Again, thanks.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply