Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Confused over backups
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00429798
Message ID:
00429818
Views:
13
I don't believe that the Maintenance Plan wizard has a facility to schedule diff. backups.

>> What is the difference between a backup schedule and a maintenance plan that includes a backup?

When you schedule a backup, the SEM creates a TSQL jobs that executes BACKUP DATABASE. On the other hand, when you do a backup within a Maintenance Plan, all the work is done through an extended stored procedure ( master.dbo.xp_sqlmaint).
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform