Log Backups

Last Post 10 Oct 2011 07:36 AM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy