DML & DDL Changes Revert

• Rechana Rajan

  SSCertifiable

  Points: 7742

  More actions

  August 31, 2016 at 2:22 pm

  #312946

  We have full backup midnight and log backup every one hour.

  We had a release and as part of that we did many DML & DDL Changes, after a few hours we realised that we want to undo the changes we made. How can we make that happen keeping the database upto date?

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  August 31, 2016 at 2:45 pm

  #1898655

  Run your rollback scripts.

  If you don't have rollback scripts, then you're looking at restoring a copy of the database to a point before the deployment and then trying to synchronise data and structure changes. Not trivial, mistakes easy to make.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Rechana Rajan

  SSCertifiable

  Points: 7742

  More actions

  September 1, 2016 at 2:07 am

  #1898700

  GilaMonster (8/31/2016)

  ---

  Run your rollback scripts.

  If you don't have rollback scripts, then you're looking at restoring a copy of the database to a point before the deployment and then trying to synchronise data and structure changes. Not trivial, mistakes easy to make.

  Thanks , no rollback scripts available . Seems like its going to be a hard day.

• September 2, 2016 at 3:33 am

  This was removed by the editor as SPAM