private void Button3_Click(
object sender, System.EventArgs e)
{
//引用SQLDMO.dll,SQLDMO由Microsoft SQL Server自带的SQLDMO.dll提供,SQLDMO.dll是一个COM对象
SQLDMO.Backup backup=
new SQLDMO.BackupClass();
SQLDMO.SQLServer sqlserver=
new SQLDMO.SQLServerClass();
sqlserver.LoginSecure=
false;
sqlserver.Connect("localhost","sa","1");
backup.Action=SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
backup.Database="userdb";
backup.Files=@"E:\Project\meng\data\userdb.bak";
backup.BackupSetName="userdb";
backup.BackupSetDescription="数据库备份";
backup.Initialize=
true;
backup.SQLBackup(sqlserver);
}
private void Button4_Click(
object sender, System.EventArgs e)
{
SQLDMO.Restore restore=
new SQLDMO.RestoreClass();
SQLDMO.SQLServer sqlserver=
new SQLDMO.SQLServerClass();
sqlserver.LoginSecure=
false;
sqlserver.Connect("192.168.19.25","sa","sa"); restore.Action=SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
restore.Database="userdb";
restore.Files=@"E:\Project\meng\data\userdb.bak";
restore.BackupSetName="userdb";
restore.FileNumber=1;
restore.SQLRestore(sqlserver);
}
//得到指定SQL服务器所有数据库的列表
public ArrayList GetDataBaseList(
string ServerName,
string UserName,
string Pwd)
{
ArrayList list =
new ArrayList() ;
SQLDMO.Application sqlApp =
new SQLDMO.Application() ;
SQLDMO.SQLServer oServer =
new SQLDMO.SQLServer() ;
oServer.Connect(ServerName,UserName,Pwd);
foreach(SQLDMO.Database db
in oServer.Databases)
{
if((db.Name!=
null) && (db.SystemObject ==
false))
list.Add(db.Name);
}
return list ;
}
//得到SQL服务器的列表
public ArrayList GetSqlServerList()
{
ArrayList list =
new ArrayList() ;
SQLDMO.Application sqlApp =
new SQLDMO.Application();
SQLDMO.NameList ServerName = sqlApp.ListAvailableSQLServers();
for(
int i=0;i<ServerName.Count;i++)
{
list.Add(ServerName.Item(i+1));
}
return list;
}