using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Web;
using?System.Configuration;
using?System.Data.SqlClient;
///?

///?DbOper?的摘要說明
///?

public?class?DbOper
{
????public?class?DbOper
????{

????????private?string?server;

????????private?string?uid;

????????private?string?pwd;

????????private?string?database;

????????private?string?conn;

????????///?


????????///?DbOper類的構(gòu)造函數(shù)

????????///?


????????public?DbOper（）
????????{

????????????conn?=?ConfigurationManager.ConnectionStrings[“Connect“].ToString（）;


????????????server?=?cut（conn?“server=“?“;“）;

????????????uid?=?cut（conn?“uid=“?“;“）;

????????????pwd?=?cut（conn?“pwd=“?“;“）;

????????????database?=?cut（conn?“database=“?“;“）;

????????}

????????public?string?cut（string?str?string?bg?string?ed）
????????{

????????????string?sub;

????????????sub?=?str.Substring（str.IndexOf（bg）?+?bg.Length）;

????????????sub?=?sub.Substring（0?sub.IndexOf（“;“））;

????????????return?sub;

????????}



????????///?


????????///?數(shù)據(jù)庫(kù)備份

????????///?


????????public?bool?DbBackup（string?url）
????????{

????????????SQLDMO.Backup?oBackup?=?new?SQLDMO.BackupClass（）;

????????????SQLDMO.SQLServer?oSQLServer?=?new?SQLDMO.SQLServerClass（）;

????????????try
????????????{

????????????????oSQLServer.LoginSecure?=?false;

????????????????oSQLServer.Connect（server?uid?pwd）;

????????????????oBackup.Action?=?SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;

????????????????oBackup.Database?=?database;

????????????????oBackup.Files?=?url;//“d:\Northwind.bak“;

????????????????oBackup.BackupSetName?=?database;

????????????????oBackup.BackupSetDescription?=?“數(shù)據(jù)庫(kù)備份“;

????????????????oBackup.Initialize?=?true;

????????????????oBackup.SQLBackup（oSQLServer）;

????????????????return?true;

????????????}

????????????catch
????????????{

????????????????return?false;

????????????????throw;

????????????}

????????????finally
????????????{

????????????????oSQLServer.DisConnect（）;

????????????}

????????}



????????///?


????????///?數(shù)據(jù)庫(kù)恢復(fù)

????????///?


????????public?string?DbRestore（string?url）
????????{

????????????if?（exepro（）?!=?true）//執(zhí)行存儲(chǔ)過程
????????????{

????????????????return?“操作失敗“;

????????????}

????????????else
????????????{

????????????????SQLDMO.Restore?orestore?=?new?SQLDMO.RestoreClass（）;

????????????????SQLDMO.SQLServer?oSQLServer?=?new?SQLDMO.SQLServerClass（）;

????????????????try
????????????????{

????????????????????oSQLServer.LoginSecure?=?false;

????????????????????oSQLServer.Connect（server?uid?pwd）;

????????????????????orestore.Action?=?SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;

????????????????????orestore.Database?=?database;

????????????????????orestore.Files?=?url;//@“d:\Northwind.bak“;

???????????????????

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件?????355032??2005-10-14?18:46??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\msvcr71.dll

?????文件?????585728??2005-05-04?00:21??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\Resources\1033\sqldmo.rll

?????文件?????585728??2005-05-04?00:21??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\Resources\2052\sqldmo.rll

?????文件????4558848??2005-09-30?10:33??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\SQLDMO.DLL

?????文件????????747??2012-12-17?10:04??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\read?me.txt

?????文件?????950272??2013-02-16?10:20??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\Bin\Interop.SQLDMO.dll

?????文件???????4313??2013-02-16?10:39??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\DbOper.cs

?????文件????????605??2013-02-16?10:38??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\Default.aspx

?????文件???????4955??2013-02-16?10:56??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\Default.aspx.cs

?????文件????????258??2013-02-16?10:20??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\vwd.webinfo

?????文件???????1527??2013-02-16?10:35??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\Web.config

?????文件????????611??2013-02-16?11:10??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\需要建立的存儲(chǔ)過程.txt

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\Resources\1033

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\Resources\2052

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn\Resources

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools\Binn

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80\Tools

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server\80

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）\Microsoft?SQL?Server

?????目錄??????????0??2013-02-16?10:20??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)\Bin

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\sqldmo?（1）

?????目錄??????????0??2013-02-16?11:08??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）\備份還原數(shù)據(jù)庫(kù)

?????目錄??????????0??2013-02-16?11:10??asp.net?備份還原數(shù)據(jù)庫(kù)（C#）

-----------?---------??----------?-----??----

??????????????7048624????????????????????23