Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

MSSQLÈÕÖ¾Îļþ¼°Æä´¦ÀíÏê½â


ÈçºÎÇå³ýMSSQLÊÂÎñÈÕÖ¾Îļþ
   ÈýÖÖ·½·¨£º  
    
1¡¢É¾³ýLOG  
    
   1)£º·ÖÀëÊý¾Ý¿âÆóÒµ¹ÜÀíÆ÷£­£¾·þÎñÆ÷£­£¾Êý¾Ý¿â£­£¾ÓÒ¼ü£­£¾·ÖÀëÊý¾Ý¿â      
   2)£ºÉ¾³ýLOGÎļþ  & ......

C#ÖÐʹÓÃDataTableÏÔʾAccessÊý¾Ý¿âÖÐÎļþÁбí


private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
             this.comboBox2.Items.Clear();
            switch(this.comboBox1.SelectedIndex)
       ......

MSSQLµÄIndexÒ²ÒªÓÅ»¯¡£

ÔÚ´¦ÀíϵͳÓÅ»¯µÄʱºò£¬·¢ÏÖindexʹÓò»µ±µÄ»°£¬ÏµÍ³µÄÐÔÄܲ»Äܺܺ÷¢»Ó¡£
È磺½ñÌìµÄ·¢ÏÖµÄÒ»¸ösqlÓï¾ä£¬¾­¹ý·ÖÎö£¬Ê¹ÓÃÁË2¸öindex¡£µ«ÊÇ2¸öindex·µ»ØµÄ¼Ç¼ÔÚ»¥ÏàÆ¥Åä¹ý³ÌÖкÄʱ×î¶à¡£ËùÒÔ£¬¼´Ê¹SQLÓï¾äʹÓÃindex£¬Ò²²»´ú±íÕâ¸öÓï¾äÔÚÐÔÄÜÉÏÊǺܺõġ£ ......

ASP.netÒ³ÃæÊµÏÖMSSQLÊý¾Ý¿âµÄ´´½¨ºÍ²Ù×÷£¬Êǿⴴ½¨£¡

///   <summary>  
        ///   ´´½¨Êý¾Ý¿â¡£  
        ///   </summary>
        ///   <param name="srvName">±íÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ