You must Sign In to post a response.
  • Category: SQL Server

    How to Get back original SP

    HI friends,

    I have one original Stored Procedure. i was wrongly overwrite that sp in that sql server. There is no backup for this sp. Now i have to getback that Stored Procedure. How can i do that?? Kindly help to do that..
  • #748398
    If you have generated a script file previously for this stored procedure then you can retrieve this storedprocedure from the script file.
    Miss. Jain
    Microsoft Certified Technology Specialist in .Net

  • #748406
    Hi,

    Do you have back up for your database, if you have you can restore the data base and get the stored procedure from it.

    Thanks and Regards
    S.Suresh

    "IF YOU WANT TO SHINE LIKE A SUN FIRST YOU HAVE BURN LIKE IT".

  • #748416
    Hi,

    If you are using VSS/ FTS then you can able to get the history of that. Without that if you are doing at-least you should save that in temporary location. Without that i think that's not possible to get the previous version. Please checkout in your system hard disk it might be any backup for that.

    Hope you understood...

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #748426
    You cant retrieve the procedure only if you have created any backup or stored in any source control else you will not be able to recover it.
    Dharmendra Kumar
    dharmendra.hbti@gmail.com
    +919911308352
    http://blog.dkumar.co.in

  • #748443
    You can't retrieve a previous copy from the current database. Unless you have kept a script in source control or elsewhere your only option is to restore an older backup to another environment and script out the old version from that.

  • #748504
    Hi,

    if you have any backup of database then only you can retrieve that stored procedure. Or if you have any script generated for that stored procedure, then you can get it back.

    Thanks,
    Ashutosh Jha
    http://tricksroad.com

  • #748555
    No you cannot do this.
    If you have database script or database than only you can do this,
    Most likely you can not do that.

    Regards,
    Nirav Prabtani (Senior Web Developer)
    Email : niravjprabtani@gmail.com
    blog : niravprabtani.blogspot.in


  • Sign In to post your comments