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 |
|
jon3k
Starting Member
49 Posts |
 Posted - 2007-08-20 : 10:59:47
|
| Database is about 60GB, full recovery model. Maintenance plan set to the default schedule of daily transaction log backup (except Sunday) and weekly full backups.During the full backup, the transaction log grows from 1.3GB to over 40GB.Anybody want to venture a guess as to why? |
|
|
cwalston
Starting Member
25 Posts |
Posted - 2007-08-20 : 11:23:38
|
| Is the backup occurring at the same time as a heavy load of transactions? |
 |
|
|
jon3k
Starting Member
49 Posts |
Posted - 2007-08-20 : 11:46:01
|
| Shouldn't be, activity seems pretty light at the time, no DTS packages scheduled at that time. I'm going to try and move the backup to a few hours earlier. It's very consistent, growing the same amount at the exact same time every week. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-20 : 13:01:57
|
| how long does your full backup take? |
|
|
|
jon3k
Starting Member
49 Posts |
Posted - 2007-08-20 : 15:07:18
|
| About 45 minutes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-20 : 23:06:04
|
| Do you rebuild index before backup? |
|
|
|
|
|
|
Transaction log grows during full backup