Hi,
having used the Maintenance Plan Wizard to perform back-ups for databases A,
B and C, this schedules the 'DB BAckup job for MyPlan'.
1) Are the databases backed up one at a time or are 3 back-up jobs started
at the same time?
2) If the back-ups are sequential, can I tell what order they run?
Thanks.I used this query to look at the historical data of the completed backups:
select backup_set_id,database_name, backup_start_date,backup_finish_date
from backupset
where database_name in ('master','msdb','model')
and backup_start_date > '20051115'
order by backup_set_id
And following are my conclusions:
1) Are the databases backed up one at a time or are 3 back-up jobs started
at the same time?
Databases will be backed up one after the other.
2) If the back-ups are sequential, can I tell what order they run?
In alphbetical order of the databases name.
"Gramps" wrote:
> Hi,
>
> having used the Maintenance Plan Wizard to perform back-ups for databases
A,
> B and C, this schedules the 'DB BAckup job for MyPlan'.
> 1) Are the databases backed up one at a time or are 3 back-up jobs started
> at the same time?
> 2) If the back-ups are sequential, can I tell what order they run?
>
> Thanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment