When we are planning deployment into production, how do we decide(list of table considered) if the DB backup and restore is required (in case of backout scenario). I am aware that if the deployment package contains only rulesets , we can repoint the application version.
Its always recommended to take DB back up of production before the start of deployment. In case of rollback the deployment we can restore the DB. This will keep production environment up and running with out any downtime.
Note: Best practice include the DB backup steps and time in the release notes.