<add key="CONN_STRING" value="server=smiles;uid=sa;pwd=sa;database=log1;" />
public bool DbBackup(string url)
{
conn = System.Configuration.ConfigurationManager.AppSettings["CONN_STRING"].ToString();
server = cut(conn, "server=", ";");
uid = cut(conn, "uid=", ";");
pwd = cut(conn, "pwd=", ";");
database = cut(conn, "database=", ";");
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.Files = @"\\cxc\007\Northwind.bak"; //网络上的共享文件夹
oBackup.BackupSetName = database;
oBackup.BackupSetDescription = "数据库备份";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
return true;
}
catch
{
return false;
throw;
}
finally
{
oSQLServer.DisConnect();
}
}
浙公网安备 33010602011771号