如何使用代码备份SQL Server数据库
1.添加引用
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
2.
Backup bkpDatabase = new Backup();
// Set the backup type to a database backup
bkpDatabase.Action = BackupActionType.Database;
// Set the database that we want to perform a backup on
bkpDatabase.Database = DbName;// cmbDatabase.SelectedItem.ToString();
// Set the backup device to a file
//new BackupDeviceItem(saveBackupDialog.FileName, DeviceType.File);
BackupDeviceItem bkpDevice = new BackupDeviceItem(NewName, DeviceType.File);
// Add the backup device to the backup
bkpDatabase.Devices.Add(bkpDevice);
// Perform the backup
bkpDatabase.SqlBackup(SD.SrvSql);
File.Copy(Source, PathDestination + "\\" + fileName);
File.Delete(Source);
详细参见MSDN
https://msdn.microsoft.com/en-us/library/ms162133(v=sql.120).aspx
http://sridharbabuk.blogspot.com/2009/07/sql-server-database-backups-using-smo.html
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步