C#数据库备份还原.docVIP

1．?在用户的配置时，我们需要列出当前局域网内所有的数据库服务器，并且要列出指定服务器的所有数据库，实现代码如下：?取得数据库服务器列表：?public?ArrayList?GetServerList()?{?ArrayList?alServers?=?new?ArrayList()?;?SQLDMO.Application?sqlApp?=?new?SQLDMO.ApplicationClass()?;?try?{?SQLDMO.NameList?serverList?=?sqlApp.ListAvailableSQLServers()?;?for(int?i?=?1;i=?serverList.Count;i++)?{?alServers.Add(serverList.Item(i))?;?}?}?catch(Exception?e)?{?throw(new?Exception(取数据库服务器列表出错：+e.Message))?;?}?finally?{?sqlApp.Quit()?;?}?return?alServers?;?}?取得指定数据库服务器的数据库列表?public?ArrayList?GetDbList(string?strServerName,string?strUserName,string?strPwd)?{?ServerName?=?strServerName?;?UserName?=?strUserName?;?Password?=?strPwd?;?ArrayList?alDbs?=?new?ArrayList()?;?SQLDMO.Application?sqlApp?=?new?SQLDMO.ApplicationClass()?;?SQLDMO.SQLServer?svr?=?new?SQLDMO.SQLServerClass()?;?try?{?svr.Connect(ServerName,UserName,Password)?;?foreach(SQLDMO.Database?db?in?svr.Databases)?{?if(db.Name!=null)?alDbs.Add(db.Name)?;?}?}?catch(Exception?e)?{?throw(new?Exception(连接数据库出错：+e.Message))?;?}?finally?{?svr.DisConnect()?;?sqlApp.Quit()?;?}?return?alDbs?;?}? 　2．?数据库的备份和实时进度显示代码：?public?bool?BackUPDB(string?strDbName,string?strFileName,?ProgressBar?pgbMain)?{?PBar?=?pgbMain?;?SQLDMO.SQLServer?svr?=?new?SQLDMO.SQLServerClass()?;?try?{?svr.Connect(ServerName,UserName,Password)?;?SQLDMO.Backup?bak?=?new?SQLDMO.BackupClass();?bak.Action?=?0?;?bak.Initialize?=?true?;?SQLDMO.BackupSink_PercentCompleteEventHandler?pceh?=?new?SQLDMO.BackupSink_PercentCompleteEventHandler(Step);?bak.PercentComplete?+=?pceh;?bak.Files?=?strFileName;?bak.Database?=?strDbName;?bak.SQLBackup(svr);?return?true?;?}?catch(Exception?err)?{?throw(new?Exception(备份数据库失败+err.Message))?;?}?finally?{?svr.DisConnect()?;?}?}?private?void?Step(string?message,int?percent)?{?PBar.Value?=?percent?;?}?其中，这两个语句实现了进度的实时显示：?SQLDMO.BackupSink_PercentCompleteEventHandler?pceh?=?new?SQLDMO.BackupSink_PercentCompleteEventHandler(Step);