C#备份SQL数据库

Question

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

Answer 1

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);
}
以上代码来自下面的文章
参考:
SQL Server 2005 Database Backup and Restore using C# and .NET 2.0
http://www.codeproject.com/Articles/26390/SQL-Server-2005-Database-Backup-and-Restore-using