/// <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; } }