使用WebClient类中的eKing.CmdDownLoadDbBakOper，实现数据库备份文件的定时拷贝到文件服务器的功能

3、在B运行计划任务&＃xff0c;每天定时从A的8088端口网站下载数据库备份文件到B

1、利用iis&＃xff0c;无需架设ftp

2、利用防火墙&＃xff0c;确保只能指定IP和端口可以访问

3、利用windows计划任务&＃xff0c;每天定时备份

4、备份成功邮件定时提醒

http://www.lookdaima.com/WebForms/WebPages/Blanks/Pm/Docs/DocItemDetail.aspx?id&＃61;f51e119e-68d4-49f6-8480-0c967d84902e&EmDocDetailShowTypeV&＃61;2

1、在A服务器每天定时备份数据文件到D:\DataBase\AutoBackAll目录的LookDaiMaDB下

2、在A服务器的D:\DataBase\AutoBackAll目录下架设一个IIS网站&＃xff0c;端口8088

架设网站

3、在腾讯云服务器上设置安全策略&＃xff0c;只能B服务器才能访问8088端口

腾讯云设置安全策略

腾讯云设置安全防火墙规则的方法指引

腾讯云怎么设置防火墙安全

4、&＃xff08;重复安全设置&＃xff09;在A服务器防火墙设置只有B服务器才能访问

防火墙设置

SqlServer2008数据库被人扫sa密码攻击的发现和通过windows防火墙处理知识分享

5、在IIS设置trn文件能下载&＃xff0c;见文章&＃xff1a;

让IIS7.0.0.0支持 .iso .7z .torrent .apk等文件下载的设置方法

6、在IIS网站下面添加DbLookDaiMaBak.aspx文件

实现文件的读取和下载

DbLookDaiMaBak.aspx.cs

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Reflection;
using System.Security.Cryptography;
using System.Text;
using System.IO;

public partial class DbLookDaiMaBak 
: 
System.Web.UI.Page
{

#region DateTimeGetByStrYyyyMMddHHmmss|yyyyMMddHHmmss转成时间

///

/// yyyyMMddHHmmss转成时间
///

/// 时间格式字符串(要求14位长)|如:20180621020355
/// 如果格式不正确&＃xff0c;抛出异常|否则返回时间值|如:2018-06-21 02:03:55
public DateTime DateTimeGetByStrYyyyMMddHHmmss(string str)
{
if (str &＃61;&＃61; null || str.Length &＃61;&＃61; 0)
{
throw new Exception
(
"方法&＃xff1a;"
&＃43; MethodBase.GetCurrentMethod().ReflectedType.FullName
&＃43; " "
&＃43; MethodBase.GetCurrentMethod().ToString()
&＃43; " 发生异常&＃xff1a;"
&＃43; "str &＃61;&＃61; null || str.Length &＃61;&＃61; 0"
);
}

int iLen &＃61; str.Length;

if (iLen !&＃61; 14)
{
throw new Exception
(
"方法&＃xff1a;"
&＃43; MethodBase.GetCurrentMethod().ReflectedType.FullName
&＃43; " "
&＃43; MethodBase.GetCurrentMethod().ToString()
&＃43; " 发生异常&＃xff1a;"
&＃43; "str.Length !&＃61; 8"
);
}

string dateStr
&＃61;
str.Substring(0, 4)
&＃43; "-" &＃43; str.Substring(4, 2)
&＃43; "-" &＃43; str.Substring(6, 2)
&＃43; " " &＃43; str.Substring(8, 2)
&＃43; ":" &＃43; str.Substring(10, 2)
&＃43; ":" &＃43; str.Substring(12, 2);

return DateTime.Parse(dateStr);
}



///

/// yyyyMMddHHmmss转成时间
///

/// 时间格式字符串(要求14位长)|如:20180621020355
/// 如果时间格式不正确&＃xff0c;返回的时间默认值
/// 如果格式不正确&＃xff0c;返回默认值defaultValue|否则返回时间值|如:2018-06-21 02:03:55
public DateTime DateTimeGetByStrYyyyMMddHHmmss(string str, DateTime defaultValue)
{
if (str &＃61;&＃61; null || str.Length &＃61;&＃61; 0)
{
return defaultValue;
}

int iLen &＃61; str.Length;

if (iLen !&＃61; 14)
{
return defaultValue;
}

string dateStr
&＃61;
str.Substring(0, 4)
&＃43; "-" &＃43; str.Substring(4, 2)
&＃43; "-" &＃43; str.Substring(6, 2)
&＃43; " " &＃43; str.Substring(8, 2)
&＃43; ":" &＃43; str.Substring(10, 2)
&＃43; ":" &＃43; str.Substring(12, 2);

DateTime theResult &＃61; defaultValue;

if (DateTime.TryParse(dateStr, out theResult))
{
return theResult;
}

return defaultValue;
}

#endregion DateTimeGetByStrYyyyMMddHHmmss|yyyyMMddHHmmss转成时间

#region GetGB2312MD5|获得GB2312&＃xff08;中文编码&＃xff09;格式的MD5值

///

/// 获得GB2312编码的MD5值
///

/// 需要MD5的字符串
///
public string GetGB2312MD5(string s)
{
if (s &＃61;&＃61; null)
s &＃61; "";

MD5 md5 &＃61; new MD5CryptoServiceProvider();

System.Text.Encoding en &＃61; System.Text.Encoding.GetEncoding("GB2312");

byte[] t &＃61; md5.ComputeHash(en.GetBytes(s));

StringBuilder sb &＃61; new StringBuilder(32);

for (int i &＃61; 0; i {
sb.Append(t[i].ToString("x").PadLeft(2, &＃39;0&＃39;));
}

return sb.ToString();
}

#endregion GetGB2312MD5|获得GB2312编码的MD5值


///

/// 
///

///
///
///
protected string ToSign(string callName, string dt)
{
string str &＃61; callName &＃43; dt &＃43; "ekinglbs.lookdaima";

return GetGB2312MD5(str);
}

///

/// 获得网站根目录(比如网站虚拟目录tools) - http://www.slowx.net/tools/
///

///
public string GetWebRootUrl()
{
HttpContext hc &＃61; HttpContext.Current;

if (hc &＃61;&＃61; null)
{
throw new Exception
(
"方法&＃xff1a;"
&＃43; MethodBase.GetCurrentMethod().ReflectedType.FullName
&＃43; " "
&＃43; MethodBase.GetCurrentMethod().ToString()
&＃43; " 发生异常&＃xff1a;HttpContext hc &＃61; HttpContext.Current值为null。"
);
}

// 虚拟目录加完整参数页面地址 //
// /SlowXWebSite/Test/WebCommon/Default.aspx?id&＃61;default.aspx&web&＃61;%cb%aa%d2%b6&dt&＃61;D%3a%5ccanoe%5cs.aspx&p&＃61;fdf%5cf%2ffds.fdsf%3ffdf //
string strPathAndQuery &＃61; hc.Request.Url.PathAndQuery;

// 完整URL地址 //
string strAbsoluteUri &＃61; hc.Request.Url.AbsoluteUri;

int idx &＃61; strAbsoluteUri.LastIndexOf(strPathAndQuery);

if (idx &＃61;&＃61; -1)
{

throw new Exception
(
"方法&＃xff1a;"
&＃43; MethodBase.GetCurrentMethod().ReflectedType.FullName
&＃43; " "
&＃43; MethodBase.GetCurrentMethod().ToString()
&＃43; " 发生异常&＃xff1a;"
&＃43; "int idx &＃61; strAbsoluteUri[" &＃43; strAbsoluteUri &＃43; "].LastIndexOf(strPathAndQuery[" &＃43; strPathAndQuery &＃43; "]) &＃61;&＃61; -1;"
);
}

string theResult &＃61; strAbsoluteUri.Substring(0, idx);

if (hc.Request.ApplicationPath &＃61;&＃61; "/")
return theResult;
else
return theResult &＃43; hc.Request.ApplicationPath;
}

///

/// 
///

///
protected string DataBindTheControls(bool isDebug)
{
if (isDebug)
{
string debugWebRootUrl &＃61; GetWebRootUrl();


if (debugWebRootUrl.EndsWith("/") || debugWebRootUrl.EndsWith("\\"))
{
debugWebRootUrl &＃61; debugWebRootUrl.Substring(0, debugWebRootUrl.Length - 1);
}

return "&＃43;" &＃43; debugWebRootUrl &＃43; "/debugdata.zip";

}

string noPower &＃61; "-鉴权失败:" &＃43; Request.Url.AbsoluteUri;

string callName &＃61; Request.QueryString["CallUserName"];
string dt &＃61; Request.QueryString["dt"];
string sign &＃61; Request.QueryString["sign"];

if (callName &＃61;&＃61; null || callName.Length &＃61;&＃61; 0)
return noPower &＃43; "[callName]";

if (dt &＃61;&＃61; null || dt.Length &＃61;&＃61; 0)
return noPower &＃43;"[dt]";

if (sign &＃61;&＃61; null || sign.Length &＃61;&＃61; 0)
{
return noPower &＃43; "[sign]";
}

DateTime dtValue &＃61; DateTimeGetByStrYyyyMMddHHmmss(dt, DateTime.MinValue);

if (dtValue &＃61;&＃61; DateTime.MinValue)
{
return noPower &＃43; "[dt.MinValue]";
}

if (callName !&＃61; "ekinglbs")
{
return noPower &＃43; "[callName&＃61;" &＃43; callName &＃43; "]";
}

string newSign &＃61; ToSign(callName, dt);

if (newSign !&＃61; sign)
{
return noPower &＃43; "[callName&＃61;" &＃43; callName &＃43; "]" &＃43; "[dt&＃61;" &＃43; dt &＃43; "]" &＃43; "[sign&＃61;" &＃43; sign &＃43; "]" &＃43; "[newSign&＃61;" &＃43; newSign &＃43; "]";
}

string rootDir &＃61; Request.PhysicalApplicationPath &＃43; "LookDaiMaDB";

DirectoryInfo dir &＃61; new DirectoryInfo(rootDir);

if (!dir.Exists)
{
return "-目录" &＃43; dir.FullName &＃43; "不存在";
}

FileInfo[] fA &＃61; dir.GetFiles();

string webRootUrl &＃61; GetWebRootUrl();

if (webRootUrl.EndsWith("/") || webRootUrl.EndsWith("\\"))
{
webRootUrl &＃61; webRootUrl.Substring(0, webRootUrl.Length - 1);
}

foreach (FileInfo fi in fA)
{
if (fi &＃61;&＃61; null)
continue;

if (fi.Extension &＃61;&＃61; null)
continue;

if (fi.Extension.Trim().ToLower() !&＃61; ".trn")
{
continue;
}

if (fi.LastWriteTime.Date !&＃61; DateTime.Now.Date)
{
continue;
}

return "&＃43;" &＃43; webRootUrl &＃43; "/LookDaiMaDB/" &＃43; fi.Name;
}

return "-没有找到文件";
}

///

/// 转换成要下载的文件路径
///

///
///
protected void Page_Load(object sender, EventArgs e)
{
Response.ContentEncoding
&＃61;
System.Text.Encoding.GetEncoding("gb2312"); 

if (!this.IsPostBack)
{
try
{
string str &＃61; DataBindTheControls(false);

Response.Write(str);
}
catch (Exception err)
{
Response.Write("-系统异常&＃xff1a;" &＃43; err.Message);
}
}
}
}

访问地址&＃xff1a;http://10.186.73.30:8088/DbLookDaiMaBak.aspx

7、在B服务器部署控制台下载程序

控制台目录&＃xff1a;C:\Cmds\CS\common\DownLoadDbBak

下载存放目录&＃xff1a;C:\WebBackups\DBs\LookDaiMa

DownLoadDbBak.zip

bat脚本&＃xff1a;

downdb.bat

C:\Cmds\CS\common\DownLoadDbBak\eKing.CmdDownLoadDbBakOper.exe EmailName&＃61;qq89616537 EmailSmtpServer&＃61;smtp.163.com EmailSend&＃61;qq89616537&＃64;163.com EmailPwd&＃61;[****密码隐藏***] EnableSsl&＃61;false EmailRecv&＃61;89616537&＃64;qq.com;qq89616537&＃64;163.com; EmailTitle&＃61;{Oper}.{DateTime.Date}-看代码网数据库备份文件拷贝归档操作 EmailText&＃61;看代码网数据库备份文件拷贝归档操作 EmailEncoding&＃61;gb2312 HtmlFlag&＃61;false PwdTextType&＃61;des3 ConsoleWriteFlag&＃61;true DownLoadUrl&＃61;"http://10.186.73.30:8088/DbLookDaiMaBak.aspx?" CallUserName&＃61;ekinglbs CallPwd&＃61;lookdaima CallPwdTextType&＃61;text DayLeft&＃61;5 SaveDir&＃61;C:\WebBackups\DBs\LookDaiMa SaveFileName&＃61;lookdaima.trn

利用WebClient|eKing.CmdDownLoadDbBakOper|实现定时拷贝数据库备份文件到文件服务器

8、双击bat测试执行

9、利用windows计划任务实现每天定时执行bat

通过windows计划任务和bat脚本实现定时获取表空间大小的操作指引攻略