使用C＃和放大器; SMO，我怎么备份设备添加到SQL Server？ [英] Using C# & SMO, how do I add a backup device to a SQL Server?

问题描述

我知道如何使用C＃和SMO来创建SQL Server上的文件备份：

I know how to use C# and SMO to create a file backup on a SQL Server:

public void BackupDatabase(Microsoft.SqlServer.Management.Smo.Server server, 
                               string databaseName, string backupFilename,
                               string backupName, string backupDescription) {

 Backup backup = new Backup();
 backup.Devices.AddDevice(backupFilename, DeviceType.File);
 backup.Database = databaseName;
 backup.Action = BackupActionType.Database;
 backup.BackupSetDescription = backupDescription;
 backup.BackupSetName = backupName;
 backup.Incremental = false;
 backup.LogTruncation = BackupTruncateLogType.Truncate;
 backup.Initialize = true; // supposed to overwrite
 backup.SqlBackup(server);
}

我不知道（也不可能找到）是如何文件BackupDevice添加到SQL服务器。

What I don't know (and can't find) is how to add the file BackupDevice to the SQL server.

推荐答案

使用的 BackupDevice.Create ：

Server server = new Server("localhost");
BackupDevice newDevice = new BackupDevice();
newDevice.Parent = server;
newDevice.Name = "newDevice";
newDevice.BackupDeviceType = BackupDeviceType.Disk;
newDevice.PhysicalLocation = "c:\temp\newdevice.bak";
newDevice.Create();

这篇关于使用C＃和放大器; SMO，我怎么备份设备添加到SQL Server？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！