Log Backups

Last Post 10 Oct 2011 07:36 AM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
broberts119
New Member
New Member

--
10 Oct 2011 07:10 AM
Need to know why/how the first log backup after a db backup is the same size as the db?   Very few transactions occurred between the db backup and the log backup...   All help/thoughts greatly appreciated....

gunneyk
New Member
New Member

--
10 Oct 2011 07:36 AM
Log backups always go from the last log backup to current. It is initialized by the very first full backup but after that any additional FULL backups will not affect the entries in the log that need to be backed up when a log backup occurs. So there could have been a lot of transactions since the last log backup. The idea is to have many log backups.


Acceptable Use Policy
---