• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 817
  • Last Modified:

help- urgent recover stored procedure

i am using MS-SQL server 2000. i have 2 databases. one is production and the other one is testing. i recently created a testing stored prodcedure in the test database. but forgot that the test database get overwritten everynight because the test database is also treat as the backup database. so how do i restore the store procedure in the test database? help me plz.
0
StewSupport
Asked:
StewSupport
3 Solutions
 
R_JanssenCommented:
It's gone if you are using a real backup and not replication. Always make sure you save your scripts.
 
0
 
StewSupportAuthor Commented:
dang it no other way?
0
 
chapmandewCommented:
It is gone unless you have a backup of the database.
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
BrandonGalderisiCommented:
Or by chance still have it open in Query analyzer somewhere, or saved locally.
0
 
StewSupportAuthor Commented:
not the solution i guess there are none so i just give points to you for trying thanks
0
 
BrandonGalderisiCommented:
But it is the solution.  The "solution" is the answer to your question.  And unfortunately, sometimes the answer is there is no way to do it.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now