Forum Discussion
what is the correct process to deploy SQL server developer script as DBA?
I am DBA currently deploying sql scripts from developers but is not clear to me what is the correct way or process to do it, my concern is about how can I reverse the changes or guarantee data integr...
If I'm doing a schema change I always either make a Full backup if the database is in SIMPLE recovery mode, or if the database is in FULL recovery mode, I mark down the time I kicked off the change and do a Point in Time recovery a couple of minutes prior to the change if their script fails.
You can do transactional rollbacks as well if all that is changed is data.