You probably know that you can mirror a backup to several destinations, assuming you are on a supported edition (Enterprise or Developer). This is not the same as striping; you can compare striping to RAID 0, and mirroring to RAID 1.
Ola now supports mirroring in his maintenance solution, found here. A couple of examples:
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup',
@MirrorDirectory = 'D:\Backup',
@BackupType = 'FULL',
@CleanupTime = 24,
@MirrorCleanupTime = 48
EXECUTE dbo.DatabaseBackup
@Databases = 'USER_DATABASES',
@Directory = 'C:\Backup,D:\Backup',
@MirrorDirectory = 'E:\Backup,F:\Backup',
@BackupType = 'FULL',
@CleanupTime = 24,
@MirrorCleanupTime = 48
Note that if any of the destinations are unanavilable, then the backup fails for all destinations. SQL Server do not produce the backup to the ones that are available. This has nothing to do with Ola’s solution, it is just how MS decided to implement backup mirroring.
Alright, fight fans! Looking for some hot ‘gachoic1’ action? This site’s got what you need. gachoic1 is where it’s at.
789pvip looks interesting, gotta say. Their VIP program seems enticing. Anyone here a member? Wanna hear your experiences with using 789pvip!
U888U888COOL on .com, huh? Had some fun times there. Fair play and a smooth interface. Worth a peek. u888u888cool
Just tried logging into bj88dangnhap.net. Smooth sailing, no issues whatsoever. If you’re looking for a hassle-free experience, might be your jam. Get there here: bj88dangnhap