by pbharg.. » Fri, 24 Sep 1999 04:00:00
If there is a difference, what are the pros and cons to each
implementation?
Thank you in advance.
Parul Bhargava
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
by Jerry Spive » Sat, 25 Sep 1999 04:00:00
HTH
Jerry
> If there is a difference, what are the pros and cons to each
> implementation?
> Thank you in advance.
> Parul Bhargava
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
1. db maint plan backup w/ devices
I have proven that our 19 gig backup is twice as fast if I
use 2 backup devices (named g and i). Device g and i point
to separate disks. Now, I want to change the db maint
plan to use these two backup devices. But I don't see a
way to specify a backup disk device in the wizard. Below
is the job that the maint plan creates, the second one is
my edit that does not work. Any ideas?
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 250B6742-61A2-
11D4-9ECE-00D0B76965A8 -Rpt "f:\temp\DB Maintenance
ALL4.txt" -DelTxtRpt 1WEEKS -BkUpMedia DISK -
BkUpDB "f:\backup" -DelBkUps 5DAYS -CrBkSubDir -
BkExt "BAK"'
EXECUTE master.dbo.xp_sqlmaint N'-PlanID FBCA36AA-EA0F-
4937-A379-E61C137DB548 -Rpt "f:\temp\DB Maintenance
Plan14.txt" -DelTxtRpt 1WEEKS -BkUpMedia DISK -
BkUpDB "i","g" -DelBkUps 5DAYS'
3. Backup device vs. backup to disk
5. Backups using the Maint Plan
7. Zipping Backup Files as part Maint. Plan
8. User group for uniVerse users
9. DB backup retention period in Maint Plan
10. backup to tape using maint.plan - is it an append or overwrite
11. System DB maint plan skips backup of Master tlog
12. Maint Plan: automatic removal of backup file
13. Maint plans and differential backup