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:40:46
|
| 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:27:42
|
| You have to take transaction log backup frequently to avoid this scenerio. Use DBCC shrinkfile to shrink log file. |
 |
|
|
xgirl
Starting Member
6 Posts |
Posted - 2008-03-17 : 12:21:42
|
| My question is why is the tran log growing so quickly overnight on Thursday. If there is a large import of data, you may want to backup and shrink immediately following that job. Reindexing will also cause trans logs to grow. Check these out in order to anticipate a large growth spurt in the trans log. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-17 : 12:27:04
|
| Are you asking for suggestion or giving suggestion? |
|
|
|
xgirl
Starting Member
6 Posts |
Posted - 2008-03-17 : 17:45:28
|
| I'm suggesting |
|
|
|
|
|
|
Transaction Log Grow too big