SMO Sample: Backup database to Mirrors


Purpose of sample: Backup database to various mirrors


Server svr = new Server();


Backup b = new Backup();


b.BackupSetDescription = "Set description";
b.Action = BackupActionType.Database;
b.BackupSetName = "B
ackup set #1";
b.Database = "msdb";
b.MediaDescription =
"Media description";
b.MediaName = "M
edia name";
b.Devices.AddDevice(
@"c:\back1a.bak", DeviceType.File);
b.Devices.AddDevice(
@"c:\back1b.bak", DeviceType.File);


BackupDeviceList[] la = new BackupDeviceList[2];


BackupDeviceList l1 = new BackupDeviceList();
l1.AddDevice(
@"c:\back2a.bak", DeviceType.File);
l1.AddDevice(
@"c:\back2b.bak", DeviceType.File);


BackupDeviceList l2 = new BackupDeviceList();
l2.AddDevice(
@"c:\back3a.bak", DeviceType.File);
l2.AddDevice(
@"c:\back3b.bak", DeviceType.File);


la[0] = l1;
la[1] = l2;
b.Mirrors = la;


b.FormatMedia = true;
b.Initialize =
true;
b.SkipTapeHeader =
true;


b.SqlBackup(svr);


Disclaimer: this sample doesn't handle exceptions and may not function as expected. Use at own risk. It is good practice to test an application before using it in production.

Comments (1)

Skip to main content