Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

huge sql transaction log backup after diff db backup

Status
Not open for further replies.
nuejimmy

nuejimmy

Technical User
Jul 6, 2004
9
0
0
US
I backup a bunch of SQL Server 2000 databases on a weekly-full, nightly-differential schedule. I also back up transaction logs every 3 hours. Everything is fine except for the first transaction log backup after each nightly differential backup....it is sometimes enormous

My full backup is almost 15 GB, Differentials around 2 GB, and normal transaction logs from 10 to a few hundred MB.

Then some nites the first transaction log backup after my differential is over 15 GB! I have no idea why they are so huge all of a sudden, then back down to normal.
 
Status
Not open for further replies.

Similar threads

Martha_SysAdm
  • Locked
  • Question
Which hardware and software can i consider for Backup and Disaster recovery 1
Replies
3
Views
290
goombawaho
goombawaho
Kennymc
  • Locked
  • Question
backup exec
Replies
0
Views
194
Kennymc
Kennymc
Marino.
  • Locked
  • Question
Restore backup in Open VMS
Replies
0
Views
197
Marino.
Marino.
nmahat
  • Locked
  • Question
Symantec Backup Exec 2015: Backup Fail
Replies
0
Views
77
nmahat
nmahat
Victor ILSP
  • Locked
  • Question
Backup Not possible Failed to create a VSS snapshot
Replies
0
Views
84
Victor ILSP
Victor ILSP

Part and Inventory Search

Sponsor

Back
Top