/// <summary>
/// 添加数据备份
/// </summary>
/// <param name="datetime">备份时间</param>
/// <param name="dbName">数据库名称</param>
/// <param name="sPath">文件路径</param>
public void AddDataBackup(DateTime?datetime, string dbName, string sPath)
{
try
{
if (datetime.HasValue)
{
string dTime = datetime.Value.ToString("yyyy-MM-dd");
sPath = Path.Combine(sPath, dbName + dTime + ".bak");
string strSql = "backup database " + dbName + " to disk='" + sPath + "'";
using (var db = _dbFactory.GetDbInstance())
{
db.ExcuteSql(strSql, new { });
}
}
}
catch (Exception e)
{
_logger.WriteLog(new Log()
{
DateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
LogLevel = (int)LCore.Logger.LogLevel.Error,
ClassName = this.GetType().FullName,
ActionName = e.TargetSite.Name,
Msg = e.Message + "-----" + e.StackTrace
});
}
}
