Recover the deleted object
-
Hai....,
Is it possible to recover the deleted object(s) back to sql server (2000). Assume that i have mistakenly deleted one of my stored procedure and later repent that i should have had that procedure. What should i so in this situation. Also consider that i haven't taken the backup after creating that procedure. I don't know if this question is silly but would just like to know the scenarios.
Regards,
Hemant
-
It's not possible to get the procedure back after dropping it from the db because it deletes all the entries from the db related to that sp.
------------
Prakash Sawanthttp://psawant.blogspot.com
-
However, you can get it back if you have a backup of your database that contains it.
Restore your database ("PROD_DB") as "PROD_DB_GetTheSP_I_Mistakenly_Deleted" .... ok .... maybe a shorter name ......... just make sure not to restore on top of your Live DB.
When you restore to your new name, then you can get the SP and re-create it in PROD_DB.
-
Homebrew01 - you're not reading carefully enough - there's NO backup...
I store the scripts of all my database objects (as well as their versions) in Visual Source Safe & usually use that as my last resort if I've also deleted the backup of my backup of my backup....
But really - unless you have alternatives like backups and/or VSS etc..you can't get your db object back...
**ASCII stupid question, get a stupid ANSI !!!** -
Hi Sushila ! Long time no see .....
Are you suggesting I read the post properly before giving a response ?? Hmmm I'll think about it.
-
would I lead you wrong...yes, that's exactly what I was suggesting...do give it some serious thought..
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply