July 24, 2012 at 3:36 pm
If I have in my plan to backup all databases, and schedule it for a specific time, is the backup process asynchronous?
Does each database start backing up simultaneously at scheduled time or do the backups happen in a pre defined order?
July 24, 2012 at 3:58 pm
Depends whether you use one job with multiple steps or multiple jobs.
A single job with multiple steps will be synchronous, each step starts when the previous one ends
Multiple jobs are async, each job will start at it's scheduled time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 24, 2012 at 5:04 pm
Thank you. When I asked, I was thinking of the Maintenance Plan route, where you select all databases you want backed up. I guess in that scenario, they will be added as steps..
July 24, 2012 at 5:37 pm
sequelite (7/24/2012)
Thank you. When I asked, I was thinking of the Maintenance Plan route, where you select all databases you want backed up. I guess in that scenario, they will be added as steps..
Single step synchronous if memory serves me right. It just creates an internal loop script that goes to each database in turn.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply