SQLDMO(SQL Distributed Management Objects,SQL分布式管理对象)封装了Microsoft SQL Server数据库中的对象。SQLDMO是Microsoft SQL Server中企业管理器所使用的应用程序接口,所以它可以执行很多功能,其中当然也包括对数据库的备份和恢复。
SQLDMO由Microsoft SQL Server自带的SQLDMO.dll提供,由于SQLDMO.dll是一个COM对象,所以大家在用之前必须在.NET项目中添加对它的引用。
备份SQL SERVER数据库:
SQLDMO由Microsoft SQL Server自带的SQLDMO.dll提供,由于SQLDMO.dll是一个COM对象,所以大家在用之前必须在.NET项目中添加对它的引用。
备份SQL SERVER数据库:
public static void DBBack() ... { SQLDMO.Backup backup = new SQLDMO.BackupClass(); SQLDMO.SQLServer server = new SQLDMO.SQLServerClass(); try ...{ server.LoginSecure = false; server.Connect("localhost","sa","sa"); backup.Action = SQLDMO.SQLDMO_BACKUP_TYPE.SQLDMOBackup_Database; backup.Database = "northwind"; backup.Files = @"d:/Back/northwind.bak"; backup.BackupSetName = "northwind"; backup.BackupSetDescription = "Northwind数据库备份"; backup.Initialize = true; backup.SQLBackup(server); } catch(Exception x) ...{ throw x; } finally ...{ server.DisConnect(); } }
恢复SQL SERVER数据库:
public static void DBRestore() ... { SQLDMO.Restore restore = new SQLDMO.RestoreClass(); SQLDMO.SQLServer server = new SQLDMO.SQLServerClass(); try ...{ server.LoginSecure = false; server.Connect("localhost","sa","sa"); restore.Action = SQLDMO.SQLDMO_RESTORE_TYPE.SQLDMORestore_Database; restore.Database = "northwind"; restore.Files = @"D:/Back/Northwind.bak"; restore.FileNumber = 1; restore.ReplaceDatabase = true; restore.SQLRestore(server); } catch(Exception x) ...{ throw x; } finally ...{ server.DisConnect(); } }