SQL Server Database Backup using C# -------- using Microsoft.SqlServer.Management.Smo; using Microsoft.SqlServer.Management.Common; -------------------------------------- public void BackupDatabase(string databaseName, string userName, string password, string serverName, string destinationPath) { //Define a Backup object variable. Backup sqlBackup = new Backup(); //Specify the type of backup, the description, the name, and the database to be backed up. sqlBackup.Action = BackupActionType.Database; sqlBackup.BackupSetDescription = "BackUp of:" + databaseName + "on" + DateTime.Now.ToShortDateString(); sqlBackup.BackupSetName = "FullBackUp"; sqlBackup.Database = databaseName; //Declare a BackupDeviceItem BackupDeviceItem deviceItem = new BackupDeviceItem(destinationPath + "FullBackUp.bak", DeviceType.File); //Define Server connection ServerConnection connection = new ServerConnection(serverName, userName, password); //To Avoid TimeOut Exception Server sqlServer = new Server(connection); sqlServer.ConnectionContext.StatementTimeout = 60 * 60; Database db = sqlServer.Databases[databaseName]; sqlBackup.Initialize = true; sqlBackup.Checksum = true; sqlBackup.ContinueAfterError = true; //Add the device to the Backup object. sqlBackup.Devices.Add(deviceItem); //Set the Incremental property to False to specify that this is a full database backup. sqlBackup.Incremental = false; sqlBackup.ExpirationDate = DateTime.Now.AddDays(3); //Specify that the log must be truncated after the backup is complete. sqlBackup.LogTruncation = BackupTruncateLogType.Truncate; sqlBackup.FormatMedia = false; //Run SqlBackup to perform the full database backup on the instance of SQL Server. sqlBackup.SqlBackup(sqlServer); //Remove the backup device from the Backup object. sqlBackup.Devices.Remove(deviceItem); }
Posted on: Thu, 27 Jun 2013 05:25:58 +0000
Trending Topics
Recently Viewed Topics
© 2015