c#数据库备份、恢复 sql server2000

Question

c#数据库备份、恢复 sql server2000

Answer 1

  /// <summary>
        /// 备份数据库
        /// </summary>
        public static void DbBackup()
        {
            SQLDMO.Backup oBackup = new SQLDMO.BackupClass();
            SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();
            try
            {
                oSQLServer.LoginSecure = false;
                oSQLServer.Connect("D74448BD9776457", "sa", "");   //数据连接
                oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;
                oBackup.Database = "dbs";  //要进行备份的数据库
                oBackup.Files = @"d:dbs.bak";   //备份数据库的保存路径
                oBackup.BackupSetName = "dbs";   //备份后的数据库名称
                oBackup.BackupSetDescription = "数据库备份";
                oBackup.Initialize = true;
                oBackup.SQLBackup(oSQLServer);
                MessageBox.Show("完成备份！");
            }
            catch(Exception exp)
            {
                //MessageBox.Show(exp.Message);
                MessageBox.Show("备份失败！"+exp.Message);
            }
            finally
            {
                oSQLServer.DisConnect();
            }
        }