1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10//51aspx.com
11/**//// <summary>
12/// Back 的摘要说明
13/// </summary>
14public class Back:System.Web.UI.Page
15...{
16    public Back()
17    ...{
18        //
19        // TODO: 在此处添加构造函数逻辑
20        //
21    }
22    public void Backup()
23    ...{
24        SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
25        SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
26        try
27        ...{
28            oSQLServer.LoginSecure = false;
29            oSQLServer.Connect(".", "sa", "sa");
30            oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
31            oBackup.Database = "Northwind";
32            oBackup.Files = Server.MapPath("~\\DBBackup\\") + "DBim.bak";
33            oBackup.BackupSetName = "Northwind";
34            oBackup.BackupSetDescription = "数据库备份";
35            oBackup.Initialize = true;
36            oBackup.SQLBackup(oSQLServer);
37        }
38        catch
39        ...{
40            throw;
41        }
42        finally
43        ...{
44            oSQLServer.DisConnect();
45        }
46    }
47    /**//// 
48    /// 数据库恢复
49    /// 
50    public void DbRestore()
51    ...{
52        SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
53        SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
54        try
55        ...{
56            oSQLServer.LoginSecure = false;
57            oSQLServer.Connect(".", "sa", "sa");
58            oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
59            oRestore.Database = "Northwind";
60            oRestore.Files = Server.MapPath("~\\DBBackup\\") + "DBim.bak";
61            oRestore.FileNumber = 1;
62            oRestore.ReplaceDatabase = true;
63            oRestore.SQLRestore(oSQLServer);
64        }
65        catch
66        ...{
67            throw;
68        }
69        finally
70        ...{
71            oSQLServer.DisConnect();
72        }
73    }
74}
75