void IDatabaseHelperLogger.CreateLog()
{
var assemblyDirectory = Path.GetDirectoryName(Assembly.GetEntryAssembly().Location);
var dirName = Path.Combine(assemblyDirectory, LogsFolder);
if (!Directory.Exists(dirName))
{
Directory.CreateDirectory(dirName);
}
_path =
Path.Combine(
dirName,
string.Format(LogName, DateTime.Now.ToString("yyyyMMddHHmmssfff")));
_interface.LogInfo("Log created " + _path);
}
private static void Backup(Options options)
{
var appSettings = ConfigurationManager.AppSettings;
var username = options.Username ?? appSettings["username"];
var password = options.Password ?? appSettings["password"];
var dbName = options.DatabaseName ?? appSettings["databaseName"];
var filePath = options.FilePath ?? appSettings["file"];
var host = options.Host ?? appSettings["host"];
var connStr = string.Format("Server={0};Persist Security Info=True;integrated security=false;User Id={1}; Password={2};", host, username, password);
using (var conn = new SqlConnection(connStr))
{
conn.Open();
Log.LogInfo("Creating backup.");
RunParameterLessNonQuery(conn, string.Format("BACKUP DATABASE [{0}] TO DISK = '{1}' WITH FORMAT", dbName, filePath));
}
}