/// <summary>
/// restore db to selected file but first please supply the backupfilename
/// </summary>
/// <param name="backupDBName">i need the backup file name</param>
private void RestoreDBBackup(string backupDBName)
{
try
{
string _DatabaseName = AppConns.GetDatabaseName();
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = AppConns.GetMasterConnectionString();
// string backupFolderPath = Server.MapPath(HttpContext.Current.Request.ApplicationPath) + "\\DBBackup\\"; //"DROP DATABASE " + _DatabaseName +
string backupFolderPath = Server.MapPath(HttpContext.Current.Request.ApplicationPath + "\\DBBackup\\");
string sqlQuery = " Alter Database " + _DatabaseName + " SET SINGLE_USER WITH ROLLBACK IMMEDIATE; RESTORE DATABASE " + _DatabaseName + " FROM DISK = '" + backupFolderPath + backupDBName + "'; alter database " + _DatabaseName + " set multi_user";
SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.CommandType = CommandType.Text;
sqlConnection.Open();
int iRows = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
catch (SqlException ex)
{
throw ex;
}
}
private void TakeDBBackup()
{
try
{
string _DatabaseName = AppConns.GetDatabaseName();
string _BackupName = _DatabaseName + "_" + DateTime.Now.ToString("ddMMMMyyyy_hh_mm_tt") + ".bak";
// string _BackupName = _DatabaseName + ".bak";
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = AppConns.GetConnectionString();
string backupFolderPath = Server.MapPath(HttpContext.Current.Request.ApplicationPath + "\\DBBackup\\");
string sqlQuery = "Backup database [" + _DatabaseName + "] to disk='" + backupFolderPath + _BackupName + "'";
SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
sqlCommand.CommandType = CommandType.Text;
sqlConnection.Open();
int iRows = sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
lblmessage.Text = "Back up created successfully.";
}
catch (SqlException ex)
{
throw ex;
}
}
