Solved

help- urgent recover stored procedure

Posted on 2008-09-30
6
745 Views
Last Modified: 2010-04-21
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
Comment
Question by:StewSupport
6 Comments
 
LVL 3

Assisted Solution

by:R_Janssen
R_Janssen earned 150 total points
ID: 22606353
It's gone if you are using a real backup and not replication. Always make sure you save your scripts.
 
0
 

Author Comment

by:StewSupport
ID: 22606373
dang it no other way?
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 175 total points
ID: 22606389
It is gone unless you have a backup of the database.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 39

Assisted Solution

by:BrandonGalderisi
BrandonGalderisi earned 175 total points
ID: 22606578
Or by chance still have it open in Query analyzer somewhere, or saved locally.
0
 

Author Closing Comment

by:StewSupport
ID: 31501591
not the solution i guess there are none so i just give points to you for trying thanks
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 22630384
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now