Sunday, February 12, 2012

Backing up transaction logs using two DB Maintainance Plan

If I am doing two different maintainance plan for backing up the transaction
logs of the same database of sql server. Will the transactions logs being b
acked up on plan 2 will be independent of plan 1, or will it be backup of th
e transactions done after b
ackup done by maintainance plan of 1
Please reply soon.
Thanks
Saroshthey'll be independent as long as they aren't scheduled for the exact same t
ime. each backup file's name contains the date and time (only to hour and m
inute) that the backup started so that you could have problems if both backu
ps began running at the sam
e time.
Sarosh wrote:

> If I am doing two different maintainance plan for backing up the transaction logs
of the same database of sql server. Will the transactions logs being backed up on pl
an 2 will be independent of plan 1, or will it be backup of the transactions done af
ter
backup done by maintainance plan of 1
> Please reply soon.
> Thanks
> Sarosh

No comments:

Post a Comment