Hi,
I need help in retrieving some data from our server which got deleted
accidentally while exporting a stored procedure. What happened is I forgot to
uncheck the "Export all dependednt object" while exporting the Sproc, and
lost all the live data(It was overwritten by our local data). The recovery
model which we have implemented is "SIMPLE". Is there any way in which we can
get back the data.
Also is there a way to schedule "BACKUP" so that a BACKUP of the DB
will be taken before any import or export of the data occurs.
Please help.
Thanks in advance.

You will have to restore your lost data from a previous backup - I hope you
do have backups. If not, you will have to use a product like Lumigent Log
Explorer, that recover the data from the transaction log file, provided
those entries are still there in the log file.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"MightyJoeYoung" <MightyJoeYoung (AT) discussions (DOT) microsoft.com> wrote

There is a BACKUP command, which could be called from an "Execute SQL" task.
If you want to do this every time you import (or export) data, then I assume
it would also need to be just an incremental backup.

"MightyJoeYoung" <MightyJoeYoung (AT) discussions (DOT) microsoft.com> wrote

The other answers are your best options. Just wanted to add my
sympathies...I did the same thing way back in 2000 with SQL 7. That
checkbox is one of the biggest GUI problems in all of SQL Server IMHO.

Good luck :-)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions


"MightyJoeYoung" <MightyJoeYoung (AT) discussions (DOT) microsoft.com> wrote