Post reply

DML & DDL Changes Revert

  • 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?

  • 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

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply