ADO.NET 数据库备份等操作
时间：2021-07-01 10:21:17
帮助过：18人阅读
class SqlServerBackup
{
private string database;
private string server;
private string uid;
private string pwd;
public string Database
{
get
{
return this.database;
}
set
{
this.database =
value;
}
}
public string Server
{
get
{
return this.server;
}
set
{
this.server =
value;
}
}
public string Pwd
{
get
{
return this.pwd;
}
set
{
this.pwd =
value;
}
}
public string Uid
{
get
{
return this.uid;
}
set
{
this.uid =
value;
}
}
public bool DbBackup(
string url)
{
Backup oBackup =
new BackupClass();
SQLServer oSQLServer =
new SQLServerClass();
bool result;
try
{
oSQLServer.LoginSecure =
false;
oSQLServer.Connect(this.server,
this.uid,
this.pwd);
oBackup.Action =
SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database =
this.database;
oBackup.Files =
url;
oBackup.BackupSetName =
this.database;
oBackup.BackupSetDescription =
"数据库备份";
oBackup.Initialize =
true;
oBackup.SQLBackup(oSQLServer);
result =
true;
}
catch
{
result =
false;
}
finally
{
oSQLServer.DisConnect();
}
return result;
}
public bool DbRestore(
string url)
{
bool result;
if (!
this.exepro())
{
result =
false;
}
else
{
Restore oRestore =
new RestoreClass();
SQLServer oSQLServer =
new SQLServerClass();
try
{
oSQLServer.LoginSecure =
false;
oSQLServer.Connect(this.server,
this.uid,
this.pwd);
oRestore.Action =
SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
oRestore.Database =
this.database;
oRestore.Files =
url;
oRestore.FileNumber =
1;
oRestore.ReplaceDatabase =
true;
oRestore.SQLRestore(oSQLServer);
result =
true;
}
catch
{
result =
false;
}
finally
{
oSQLServer.DisConnect();
}
}
return result;
}
private bool exepro()
{
SqlConnection conn =
new SqlConnection(
string.Concat(
new string[]
{
"server=",
this.server,
";uid=",
this.uid,
";pwd=",
this.pwd,
";database=master"
}));
SqlCommand cmd =
new SqlCommand(
"killspid", conn);
cmd.CommandType =
CommandType.StoredProcedure;
cmd.Parameters.Add("@dbname",
this.database);
bool result;
try
{
conn.Open();
cmd.ExecuteNonQuery();
result =
true;
}
catch
{
result =
false;
}
finally
{
conn.Close();
}
return result;
}
}
只需引入Interop.SQLDMO.dll
ADO.NET 数据库备份等操作
标签：string return comm enum man 数据 备份 number insecure
