Post reply

How to get backup of Accidentel Executed procedure script

  • October 15, 2012 at 12:38 am

    #263879

    Hello,

    someone executed accidentally old script in a database , have any way to get back date procedure script .

    if have, please reply me.

    Thanks

  • October 15, 2012 at 2:21 am

    #1549014

    Restore a backup copy of the database and extract the correct procedure from that copy.

    You could set up a DDL trigger to capture this kind of changes into a table.

    Unfortunately, setting it up now that the damage is done won't help, but will save the pain next time it happens.

    -- Gianluca Sartori

  • October 16, 2012 at 9:19 pm

    #1549850

    Restore the database to a test server (not to the same server that the database already exists); extract the stored procedure code and permissions on the stored procedure; put the restored database offline or detach; run the extracted scripts on the required database and grant require permissions.

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

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