DbOper类,主要应用SQLDMO实现对Microsoft SQL Server数据库的备份和恢复

Struts_Spring

using System;namespace DbService{/// <summary>/// DbOper类,主要应用SQLDMO实现对Microsoft SQL Server数据库的备份和恢复/// </summary>public sealed class DbOper{/// <summary>/// DbOper类的构造函数/// </summary>private DbOper(){}/// <summary>/// 数据库备份/// </summary>public static void DbBackup(){SQLDMO.Backup oBackup = new SQLDMO.BackupClass();SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();try{oSQLServer.LoginSecure = false;oSQLServer.Connect("localhost", "sa", "1234");oBackup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database;oBackup.Database = "Northwind";oBackup.Files = @"d:Northwind.bak";oBackup.BackupSetName = "Northwind";oBackup.BackupSetDescription = "数据库备份";oBackup.Initialize = true;oBackup.SQLBackup(oSQLServer);}catch{throw;}finally{oSQLServer.DisConnect();}}/// <summary>/// 数据库恢复/// </summary>public static void DbRestore(){SQLDMO.Restore oRestore = new SQLDMO.RestoreClass();SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServerClass();try{oSQLServer.LoginSecure = false;oSQLServer.Connect("localhost", "sa", "1234");oRestore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database;oRestore.Database = "Northwind";oRestore.Files = @"d:Northwind.bak";oRestore.FileNumber = 1;oRestore.ReplaceDatabase = true;oRestore.SQLRestore(oSQLServer);}catch{throw;}finally{oSQLServer.DisConnect();}}}}