August 7, 2010 at 6:50 am
hello experts,
i took full backup of a database backup size is 22 gb
than i took differential backup , size is 100 mb than i took Transaction log backup, size is 10 mb.
want to know i took thease backup contineuously one by one, than why differential and transaction log backups having this much size.
becouse i guess transactions might not be of that much size in between backups
jst wanna knw the reason
thank you
August 9, 2010 at 2:08 am
A Differential backup contains all the changes made to the database since the last full backup.
A Transaction log backup contains all the changes made since last full/diff/t-log backup.
Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
August 9, 2010 at 2:56 am
Sudeepta (8/9/2010)
A Transaction log backup contains all the changes made since last full/diff/t-log backup.
A transaction log backup contains all the changes made since the last transaction log backup. The only time that a transaction log backup contains the transactions back to a full/diff is when that's the very first transaction log backup after the log chain was broken and reestablished.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply