How to get backup of Accidentel Executed procedure script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to get backup of Accidentel Executed...

How to get backup of Accidentel Executed procedure script

Rate Topic

Display Mode

Topic Options

Author

Message

deepaktyagi84

Posted Monday, October 15, 2012 12:38 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 10:56 AM
Points: 14, Visits: 147

Hello,
someone executed accidentally old script in a database , have any way to get back date procedure script .
if have, please reply me.

Thanks

Post #1372569

spaghettidba

Posted Monday, October 15, 2012 2:21 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:43 AM
Points: 4,804, Visits: 8,091

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.

Get your two-cent-answer quickly
The Spaghetti DBA

Post #1372590

Siva Ram

Posted Tuesday, October 16, 2012 9:19 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 06, 2012 7:47 AM
Points: 9, Visits: 37

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.

Post #1373607

« Prev Topic | Next Topic »

Permissions