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 plan 2 will be independent of plan 1, or will it be backup of the transactions done after backup done by maintainance plan of
Please reply soon
Thank
Saroshthey'll be independent as long as they aren't scheduled for the exact same time. each backup file's name contains the date and time (only to hour and minute) that the backup started so that you could have problems if both backups began running at the same 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 plan 2 will be independent of plan 1, or will it be backup of the transactions done after backup done by maintainance plan of 1
> Please reply soon.
> Thanks
> Sarosh
Sunday, February 12, 2012
Backing up transaction logs using two DB Maintainance Plan
Labels:
backing,
database,
logs,
maintainance,
microsoft,
mysql,
oracle,
plan,
server,
sql,
transaction,
transactions
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment