C#ʹÓÃSQLDMOʵÏÖ¶ÔMSSQLÊý¾Ý¿â½øÐб¸·ÝºÍ»Ö¸´
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);
}
&nbs
Ïà¹ØÎĵµ£º
£¨Ò»£©°ÑÎļþÄÚÈÝдÈëAccessÊý¾Ý¿âµÄOLE¶ÔÏó×Ö¶ÎÖУº
if (File.Exists(txtBrow.Text) != false) // Îı¾¿òtxtBrowÖÐÄÚÈÝΪÎļþ·¾¶¼°ÎļþÃû
{
//»ñÈ¡Îļþºó׺
FileInfo p = new FileInfo(txtBrow.Text.Trim());
F_str_Type = ......
×î½ü£¬¹¤×÷µÄÉÏÐèÒª´¦ÀíÒ»ÏÂÏîÄ¿Öеļ«ÉÙÁ¿Êý¾ÝµÄÖØ¸´ÎÊÌâ¡£¾¹ý·ÖÎö£¬½á¹û·¢ÏÖÊdzÌÐò²¢·¢Ã»Óд¦ÀíºÃ¶øµ¼Öµġ£¾¹ýÒ»·¬ÃþË÷£¬¶ÔÊý¾Ý¿âÖеÄËø¼°³ÌÐòµÄ²¢·¢ÓÐÁËÒ»µãµãСµÄÐĵá£ÌØÐ´µ½´ËÀ´Óë´ó¼Ò·ÖÏíһϡ£
Ê×ÏÈ£¬ÎÒÃÇÀ´Á˽âÒ»ÏÂʲô½Ð×öËø¡£
......
ÈçͼËùʾ£¬ÔÚ°²È«ÐÔ-µÇ½Àï¿ÉÒÔ¿´µ½ÓÒ±ßÁбíÀïµÄÓû§£¬Ñ¡ÖÐÓû§ÓÒ¼ü-ÊôÐÔ¿ÉÒÔ¸ü¸ÄÓû§ÃÜÂ룬¼°Êý¾Ý¿â½ÇÉ«µÈ¡£
²é¿´Óû§Ãû£¬¼°ÃÜÂëÊÇ·ñÕýÈ·£¬¿ÉÒÔµ¥¶ÀµÇ½ ²éѯ·ÖÎöÆ÷
Èç¹ûÄܵǽ˵Ã÷ÉèÖÃÕýÈ·£¬ÔÚmssql´î½¨µÄasp cmsÀï¾³£ÒªÓõ½Óû§Ãû£¬ÃÜÂë¡£
ÏÖÔÚ¿´Ã¿¸öÊý¾ÝÏÂÃæµÄÓû§Ñ¡ÏÈçͼ
Ñ¡ÖÐÒ»¸öÒ»¸öÊý¾Ý¿â£¬»òÏÂÃæµÄÓû§Ñ ......
/// <summary>
/// ´´½¨Êý¾Ý¿â¡£
/// </summary>
/// <param name="srvName">±íÊ ......