#region Using directives
using Microsoft.SqlServer.Management.Smo; // Allow shorthand notation
#endregion
namespace SqlBackup
{
 class Program
 {
  static void Main(string[] args)
  {
   string db = «AdventureWorks»; // Define and set a variable
   Backup bck = new Backup(); // Instantiate a Backup object
   bck.Action = BackupActionType.Database; // Set Action property
   bck.BackupSetName = db + «_BackupSet»; // Set BackupSetName property
   bck.Database = db; // Set Database name property
   bck.DeviceType = DeviceType.File; // Set DeviceType property
   // Add method adds file to Devices collection
   // Must escape the backslash in C#
   bck.Devices.Add(«C:» + db + «.bak»);
   // Instantiate a Server object and
   // invoke Backup object?s SqlBackup method
   bck.SqlBackup(new Server());
  }
 }
}

Поделитесь материалом с коллегами и друзьями