读书人

C#备份SQL数据库解决方案

发布时间: 2012-07-30 16:19:05 作者: rapoo

C#备份SQL数据库
SQL数据库有备份功能,当数据库出现问题时,可以用来还原。
请问如何使用C#语句进行备份?

[解决办法]

C# code
public void BackupDatabase(String databaseName, String userName,             String password, String serverName, String destinationPath){    Backup sqlBackup = new Backup();        sqlBackup.Action = BackupActionType.Database;    sqlBackup.BackupSetDescription = "ArchiveDataBase:" +                                      DateTime.Now.ToShortDateString();    sqlBackup.BackupSetName = "Archive";    sqlBackup.Database = databaseName;    BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath, DeviceType.File);    ServerConnection connection = new ServerConnection(serverName, userName, password);    Server sqlServer = new Server(connection);        Database db = sqlServer.Databases[databaseName];        sqlBackup.Initialize = true;    sqlBackup.Checksum = true;    sqlBackup.ContinueAfterError = true;        sqlBackup.Devices.Add(deviceItem);    sqlBackup.Incremental = false;    sqlBackup.ExpirationDate = DateTime.Now.AddDays(3);    sqlBackup.LogTruncation = BackupTruncateLogType.Truncate;    sqlBackup.FormatMedia = false;    sqlBackup.SqlBackup(sqlServer);} 

读书人网 >C#

热点推荐