July 15, 2008 at 11:17 am
Hi all,
Can anybody please, let me know that how much space should be good to allocate for transaction log file, so that it doesen't run out of space?
Thanks
July 15, 2008 at 11:22 am
there is no standered for this it dependes on several facter, i can think off some like the database size, number of users, transactions activity on the db, the recovery module u choos nad the backup stratigy to go for etc...
..>>..
MobashA
July 15, 2008 at 11:26 am
1 Terrabyte
To be serious, you need to look at what is going on in your particular database. It varies from database to database.
For example, a large data warehouse in Simple recovery mode that is loaded with quarterly date four times per year will have very different needs than a database that has 100,000 rows of data added per day 1 row at a time, running in Full Recovery. Add in transaction log backups at set intervals and you change the calculation completely.
The trick is to get an idea of how heavy a transaction load the database will have on average, and plan for that.
I generally start an OLTP database at 1 Gig, and set it to 1 Gig growth. I also tend to run transaction log backups every 15 minutes, so they don't grow much anyway. That works for me, on the small-business databases I deal with. It may or may not work for you.
- 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 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply