using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using SQLDMO;
public partial class _Default : System.Web.UI.Page
{
string sql;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
//SQLDMO.Application
//SQLDMO.SQLServer
//SQLDMO.Database
//SQLDMO.NameList
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.NameList sqlServers = sqlApp.ListAvailableSQLServers();
for (int i = 0; i < sqlServers.Count; i++)
{
object srv = sqlServers.Item(i + 1);
if (srv != null)
{
sql+=srv.ToString();
}
}
Response.Write(sql);
}
protected void BackUp_Click(object sender, EventArgs e)
{
DbBackup();
}
public static void DbBackup()
{
SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("10.149.7.88", "sa", "");
oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
oBackup.Database = "Northwind";
oBackup.Files = @"d:"Northwind.bak";
oBackup.BackupSetName = "Northwind";
oBackup.BackupSetDescription = "Northwind";
oBackup.Initialize = true;
oBackup.SQLBackup(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
}
//public static void DbBackup()
//{
// SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
// SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
// try
// {
// oSQLServer.LoginSecure = false;
// oSQLServer.Connect("10.149.6.216", "sa", "satopway");
// oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
// oBackup.Database = "Interface3";
// oBackup.Files = @"d:"Interface3.bak";
// oBackup.BackupSetName = "Interface3";
// oBackup.BackupSetDescription = "DbBackup";
// oBackup.Initialize = true;
// oBackup.SQLBackup(oSQLServer);
// }
// catch
// {
// throw;
// }
// finally
// {
// oSQLServer.DisConnect();
// }
//}
public static void DbRestore()
{
SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();
SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
try
{
oSQLServer.LoginSecure = false;
oSQLServer.Connect("localhost", "sa", "satopway");
oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;
oRestore.Database = "Interface3";
oRestore.Files = @"d:"Interface3.bak";
oRestore.FileNumber = 1;
oRestore.ReplaceDatabase = true;
oRestore.SQLRestore(oSQLServer);
}
catch
{
throw;
}
finally
{
oSQLServer.DisConnect();
}
}
}
转载于:https://www.cnblogs.com/sasanet/archive/2008/02/22/1077130.html