Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JeBoy
Starting Member
7 Posts |
 Posted - 2008-03-17 : 03:34:14
|
| hello Currently I have this database DB1 6GB of size. Every Saturday night I have a full backup (.bak file)- and my backup size is 5GBEvery 4 hours (4am, 8am, 12 nn, 4pm) - everyday - I run transactional backup (.trn file)From Sunday to Thursday - each trn files are very small( 2MB is the max size.Come friday morning(4am .trn file) - grows so big - 5gb .trn file. same size as my full backup. but the rest of the friday .trn file is small.My question is how will I investigate this one - why it is happening .. and how can I make all my .trn file small.Please advice.Jeboy |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-17 : 09:28:10
|
| Duplicate post:Please lock it: |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-17 : 10:57:10
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99160_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
Transaction Log Grow too big