SQLDMO组件备份恢复数据库.docVIP

SQLDMO组件备份恢复数据库首先引用SQLDMO组件，安装完Sql Server数据库后，在VS环境中引用com组件Microsoft SQLDMO Object Library? ????????/// summary??????? /// 备份数据库，调用该方法不需要连接对象(OleDbConnection对象)，所以调用该方法时，仅需本类的空构造即可??????? /// /summary??????? /// param name=strServerIP服务器IP/param??????? /// param name=strUserId数据库服务器账号/param??????? /// param name=strPassword数据库服务器密码/param??????? /// param name=strDBName需要备份的数据库名/param??????? /// param name=strBackupPath备份路径/param??????? /// returns是否成功，当备份失败抛出异常/returns??????? public bool BackupBataBase(string strServerIP,string strUserId,string strPassword,string strDBName, string strBackupPath)??????? {??????????? SQLDMO.SQLServer server = new SQLDMO.SQLServerClass();??????????? SQLDMO.Backup backupDB = new SQLDMO.BackupClass(); ??????????? try??????????? {??????????????? server.LoginSecure = false;??????????????? server.Connect(strServerIP, strUserId, strPassword); ??????????????? backupDB.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;??????????????? backupDB.Database = strDBName;??????????????? if (strBackupPath.EndsWith(@\))??????????????????? backupDB.Files = strBackupPath + strDBName + @.bak;??????????????? else??????????????????? backupDB.Files = strBackupPath + @\ + strDBName + @.bak;??????????????? backupDB.BackupSetName = strDBName;??????????????? backupDB.Initialize = true;??????????????? backupDB.SQLBackup(server); ??????????????? return true;??????????? }??????????? catch(Exception backupFaild)??????????? {??????????????? throw new Exception(backupFaild.Message);??????????? }??????????? finally??????????? {??????????????? server.DisConnect();??????????? }??????? } ??????? /// summary??????? /// 恢复数据库，调用该方法不需要连接对象(OleDbConnection对象)，所以调用该方法时，仅需本类的空构造即可??????? /// /summary??????? /// param name=strServerIP服务器IP/param??????? /// param name=strUserId用户/param??????? /// param name=strPassword密码/param??????? /// param name=strDBName需要恢复的数据库名/param??????? /// param name=strBackupFilePath备份文件的路径/param???