ASP.NETÔ¶³Ì±¸·Ý»Ö¸´SQL ServerÊý¾Ý¿â

///<summary>
      ///±¸·ÝÊý¾Ý¿âµ½±¾µØ´ÅÅÌ
      ///</summary>
    public bool BackUp(string BackUpFile)
    {
        try
        {
          //µÚÒ»²½£ºÔÚ·þÎñÆ÷ÉÏ´´½¨ÁÙʱÎļþ¼Ð
          ExecuteSql(@"master..xp_cmdshell 'md C:\temp'");
          ExecuteSql(@"master..xp_cmdshell 'del C:\temp\*.* /q'");
          //µÚ¶þ²½£º±¸·ÝÊý¾Ý¿âµ½·þÎñÆ÷Ŀ¼
          ExecuteSql(@"backup database " + DataBaseName() + @" to disk='C:\temp\HSSY'");
          //µÚÈý²½£º¹²Ïí·þÎñÆ÷µÄ±¸·ÝĿ¼
          ExecuteSql(@"master..xp_cmdshell 'net share SQLDATABACK=C:\temp'");
          //µÚËIJ½£º¸´ÖÆ·þÎñÆ÷Éϵı¸·ÝÎļþµ½±¾µØ
          File.Copy(@"\\" + ServerIP() + @"\SQLDATABACK\HSSY", BackUpFile,true);
          
          return true;
        }
        catch (System.Data.SqlClient.SqlException E)
        {
          throw new Exception(E.Message);
        }