using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;

namespace?Test_BackUp
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}
????????//備份
????????private?void?button1_Click（object?sender?EventArgs?e）
????????{
????????????SaveFileDialog?saveFileDialog?=?new?SaveFileDialog（）;
????????????saveFileDialog.Filter?=?“（*.mdf）|*.mdf“;
????????????saveFileDialog.FilterIndex?=?0;
????????????if?（saveFileDialog.ShowDialog（）?==?DialogResult.OK）
????????????{
????????????????string?filePath?=?saveFileDialog.FileName;
????????????????SQLBACK（“KK\\SQLEXPRESS“?“nuanqi“?“123“?“BackUpTest“?filePath）;
????????????????//SQLBACK（“KK\\SQLEXPRESS“?“nuanqi“?“123“?“BackUpTest“?@“E:\BackUpTest.mdf“）;
????????????}
????????}

????????///?
????????///?SQL數據庫備份
????????///?
????????///?SQL服務器IP或（Localhost）
????????///?數據庫登錄名
????????///?數據庫登錄密碼
????????///?數據庫名
????????///?備份到的路徑
????????public?static?void?SQLBACK（string?ServerIP?string?LoginUserName?string?LoginPass?string?DBName?string?BackPath）
????????{
????????????SQLDMO.Backup?oBackup?=?new?SQLDMO.BackupClass（）;
????????????SQLDMO.SQLServer?oSQLServer?=?new?SQLDMO.SQLServerClass（）;
????????????try
????????????{
????????????????oSQLServer.LoginSecure?=?false;
????????????????oSQLServer.Connect（ServerIP?LoginUserName?LoginPass）;
????????????????oBackup.Database?=?DBName;
????????????????//oBackup.Files?=?BackPath;
????????????????oBackup.Files?=?@““?+?BackPath?+?““;
????????????????oBackup.BackupSetName?=?DBName;
????????????????oBackup.BackupSetDescription?=?“數據庫備份“;
????????????????oBackup.Initialize?=?true;
????????????????oBackup.SQLBackup（oSQLServer）;
????????????????System.Windows.Forms.MessageBox.Show（“備份成功！“）;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????throw?new?Exception（e.ToString（））;
????????????}
????????????finally
????????????{
????????????????oSQLServer.DisConnect（）;
????????????}
????????}

????????//恢復
????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????OpenFileDialog?openFileDialog?=?new?OpenFileDialog（）;
????????????openFileDialog.Filter?=?“（*.mdf）|*.mdf“;
????????????openFileDialog.FilterIndex?=?0;
????????????if?（openFileDialog.ShowDialog（）?==?DialogResult.OK）
????????????????SQLDbRestore（“KK\\SQLEXPRESS“?“nuanqi“?“123“?“BackUpTest“?@“E:\BackUpTest.mdf“）;
????????}

????????///?
????????///?SQL恢復數據庫
????????///?
????????///?SQL服務器IP或（Localhost）
????????///?數據庫登錄名