我的天空

sasa

导航

DB back up

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();
        }
    }


}

posted on 2008-02-22 09:32  By xin  阅读(281)  评论(0编辑  收藏  举报