We deploy scripts to SQL DBs part of a software deployment. We've had some issues in the past restoring DBs when the deploy didn't work.
I'd like to snapshot and consolidate as part of the rollback procedure. Are there any real dangers with doing this? The SQL DB would not be in use by except for the scripts being run against it during the deploy.