smo.Backup overwriting other backup locations

mike

hey,
I have a database with two different backups added in the Backups.. menu in SQL Server Manager. When i back up my database through code via the following code, it removes both of my other backup locations and replaces it with the one the code creates. Does anyone know how to add a location, and not replace the current ones in there!?

 

Backup bk = new Backup();

string backupFile = dbname + "newbak.bak";

bk.Action = BackupActionType.Database;

bk.Devices.AddDevice(backupFile, DeviceType.File);

bk.Database = dbname;

bk.Incremental = false;

bk.LogTruncation = BackupTruncateLogType.Truncate;

bk.SqlBackup(server);

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

mike16y ago
Anyone used this code method of backing up before?
Im just worried that because it changes the locations listed in the "Backup.." option in Management Studio by removing any that are there and replacing them with this one, that it might interfere with the regular scheduled backup that runs during the night... ?
0