Rolling Back CREATE DDL Statements

There is a myth that DDL statements can't be rolled back. This article tests and debunks the myth.

Database Snapshot Use Case: Service Migration

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.

ROLLBACK to a SAVEPOINT

Rolling Back Migrations

The ways that one rolls back deployed database changes gets more complex with the migration development philosophy.

Rollbacks Are Normal

At Google, rollbacks from deployments are normal.

DDL and TRANSACTIONS

Try Catch Throw

Difference between Delete,Truncate and drop

Rollback and Recovery Troubleshooting; Challenges and Strategies

What happens if your database deployment goes awry? Grant Fritchey has some troubleshooting advice to get you out of a bind.

Steps to rollback database changes without impacting SQL Server Log Shipping

When pushing a major release to a large production database, you want to know that you'll be able to rollback changes if the need arises. These are some simple steps which we can follow to ensure that we don't have to reconfigure log shipping all over again thereby saving time and ensuring systems are not affected when rolling back changes.