满意的工作就是对它感兴趣

希望和大家一起研究,并沉醉其中

博客园 首页 新随笔 联系 订阅 管理

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

        }

    }

posted on 2007-01-09 17:40  半瓶之迷迷糊糊  阅读(394)  评论(0)    收藏  举报