Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Is Rolling Back The Same as Failing?

By Andy Warren,

Today we have a guest editorial from Andy Warren as Steve is traveling.

Recently I was part of a team that was doing a medium size/complexity migration. We came up with a plan, met to review it, and then after the appropriate communication to all involved, went forward with the implementation. It was only at the end that we realized that although we had executed the plan well, we had missed something. It as disappointing and disheartening to be sure. We spent an excited five minutes discussing ways to fix the problem and then decided that while we thought we could fix it, the right thing to do was rollback. It was not production, we had the luxury of time, and we needed a fully vetted process before we did the same in production.

The rollback went fine, as expected and planned. But it didn’t feel good. In part because we weren’t “done” and in larger part because we had missed something that in the glaring light of hindsight should not have been missed. Making it work would have felt better. It would have been a chance to be heroic.  Maybe it would have been cathartic too, working off some guilt by doing some frantic work to make it all go. Everyone was a bit down the rest of the day, me included.

Rollbacks aren’t failures (though I’ll grant a failed rollback is a whole different thing). That’s why we plan for things to go wrong, why we keep the rollback plan as simple as possible, and why we double check that we can execute it if needed – no shortcuts. I k now this, yet I still felt bad about it.

It’s a great topic to talk about before it happens. It will reinforce the need for planning for success and failure, and it will help the team key their eyes focused on the real win – winding up in a sustainable place.

How would you feel? How would your manager (and their manager) react to a rollback? Assuming it’s not an all the time thing is a rollback an acceptable outcome, or is anything less than getting it done treated as a failure?

Total article views: 139 | Views in the last 30 days: 1
Related Articles


How to use Transactions for rollback


ROLLBACK Transaction

ROLLBACK Transaction


Rollback in SSIS



How to Rollback an entire database?

NOT transaction rollback, but application version rollback


Multiple Failures

This Friday Steve Jones has a disaster recovery poll. When you have a true disaster, often there are...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones