var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Transaction Log Question
My question is I read in the text book that all transactions are held in the transaction log until the transaction log is backup, does this also apply to a full backup?
So if I do a full backup in a maintenance plan, will all the transaction be still held in the transaction log?
I am asking this because I am implementing log shipping and was wondering if I will be able to do a full backup of a database that is implemented for log shipping?
Full backups do not truncate the transaction log. they do however include the transaction log. Only a log backup will truncate a transaction log.