发表于 2009-1-5 19:48
| 
鍦–#涓繍鐢⊿QLDMO澶囦唤鍜屾仮澶峂icrosoft SQL Server鏁版嵁搴
鍙戝竷: 2008-6-30 10:14 | 浣滆: admin | 鏌ョ湅: 26娆
鍦–#涓繍鐢⊿QLDMO澶囦唤鍜屾仮澶峂icrosoft SQL Server鏁版嵁搴, SQLDMO(SQL Distributed Management Objects锛孲QL鍒嗗竷寮忕鐞嗗璞)
灏佽浜哅icrosoft SQL Server鏁版嵁搴撲腑鐨勫璞,SQLDMO鏄疢icrosoft SQL Server涓紒涓氱鐞嗗櫒鎵浣跨敤鐨勫簲鐢ㄧ▼搴忔帴鍙ｏ紝
鎵浠ュ畠鍙互鎵ц寰堝鍔熻兘, 鍏朵腑褰撶劧涔熷寘鎷鏁版嵁搴撶殑澶囦唤鍜屾仮澶,SQLDMO鐢盡icrosoft SQL Server鑷甫鐨凷QLDMO.dll鎻愪緵锛
鐢变簬SQLDMO.dll鏄竴涓狢OM瀵硅薄,鎵浠ュぇ瀹跺湪鐢ㄤ箣鍓嶅繀椤诲湪.NET椤圭洰涓坊鍔犲瀹冪殑寮曠敤銆
涓嬮潰鏄敤C#璇█涔﹀啓鐨勭敤浜嶮icrosoft SQL Server鏁版嵁搴撳浠藉拰鎭㈠鐨勪唬鐮侊細
//鏁版嵁搴撳浠
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();
}
}
//鏁版嵁搴撴仮澶
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();
}
}
}
}
