July 30, 2008 at 10:13 am
hi,
I have a log file that is 30GB big, every 15 min. I do a translog backup, with truncate, and the files are about 10 mb.
when I look at the proberties the initial size is about 30GB,
if I only have about 10 mb of transactions every 15 min. and they are truncated, why is the initial size so big? if ones the log has been 30 GB maybe because of faulty backup. does the initial size automaticlly grow to the largest know size!?
PS the DB is about 14GB and I'm running SQL 2005
if I do a DBCC SHRINKFILE, do I get a smaller initial size??
regards
Thomas
July 30, 2008 at 11:31 am
If the database was restored from a backup, or if someone manually changed the size, it can end up being whatever size it was at that time. Also, if someone set it really high when they created the database in the first place, of course.
- 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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply