careless to remove data

I am careless to 'delete from myTable'
any other method to recover the data ?
thanks a lot..If you have not truncate your log, the data should be stay in the log
file and you should be able to restore from the log file.
Agnes wrote:
> I am careless to 'delete from myTable'
> any other method to recover the data ?
> thanks a lot..|||Restore from your most recent backup...
If it just happened and your db is in "Full Recovery" mode, backup the tran
log now
You can then RESTORE with STOPAT to do a point in time recovery
HTH. Ryan
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:emI3qwzUGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I am careless to 'delete from myTable'
> any other method to recover the data ?
> thanks a lot..
>|||Hopefully his db wasn't in "Simple" recovery..
HTH. Ryan
<stanleycn@.gmail.com> wrote in message
news:1143642476.867540.66940@.g10g2000cwb.googlegroups.com...
> If you have not truncate your log, the data should be stay in the log
> file and you should be able to restore from the log file.
>
> Agnes wrote:
>

Careless Delete SP , HOw can I recover (Urgent help)

I delete 40 SO so careless ly, Any method to recover ?Agnes wrote:
> I delete 40 SO so careless ly, Any method to recover ?
>
restore as a different database?!!|||don't you have a change management process in place with all your source cod
e
in a source code control like Visual Source Safe? Maybe you'll have to use a
backup and get them from there...
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Agnes" wrote:

> I delete 40 SO so careless ly, Any method to recover ?
>
>|||I really want to cry and don't know how to do now.
Origianll, I choose all SP and generate a SQL script , I copy the script
into SQL Analzyer , and run it
I press 'stop' carelessly, then I found all the SP are dropped already.
Then I am so stupid that close the SQL analzyer, and reopen it.
NOW, I LOST everything, I check that there is a log in
G:\Program Files\Microsoft SQL Server\MSSQL\Data\myDataBase_Log
is That I can use it recover it ''
Please help ~~~~
"Zarko Jovanovic" <mind_lessNOSPAM@.bigfoot.com>
'?:1115028697.621239@.internet.fina.hr...
> Agnes wrote:
> restore as a different database?!!|||NO, i didn't got any source safe..
"mark baekdal" <markbaekdal@.discussions.microsoft.com> glsD:8A540508-E6EF-4483-9E
AF-88CCEE65C100@.microsoft.com...
> don't you have a change management process in place with all your source
> code
> in a source code control like Visual Source Safe? Maybe you'll have to use
> a
> backup and get them from there...
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Build, Comparison and Synchronization from Source Control = Database
> change
> management for SQL Server
>
>
> "Agnes" wrote:
>|||Hi Agnes,
Since you dont have any change management system or a local copy of the
stored procedures stored as flat files.
You could probably try restoring a backup of the database.(looks like the
only way u have)
Prad
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:uW399pvTFHA.3184@.TK2MSFTNGP15.phx.gbl...
>I delete 40 SO so careless ly, Any method to recover ?
>|||Backup database ' I didn't do any back up...
"Pradeep Kutty" <pradeepk@.healthasyst.com> glsD:eGdPULwTFHA.1152@.tk2msftngp13.phx
.gbl...
> Hi Agnes,
> Since you dont have any change management system or a local copy of the
> stored procedures stored as flat files.
> You could probably try restoring a backup of the database.(looks like the
> only way u have)
> Prad
> "Agnes" <agnes@.dynamictech.com.hk> wrote in message
> news:uW399pvTFHA.3184@.TK2MSFTNGP15.phx.gbl...
>|||update your CV.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Agnes" wrote:

> Backup database ' I didn't do any back up...
> "Pradeep Kutty" <pradeepk@.healthasyst.com> ???g?ó?l￥ó·s?D:eGdPUL
wTFHA.1152@.tk2msftngp13.phx.gbl...
>
>|||Hi,
Check the recovery model for your database. If it is FULL recovery model we
can try out a Point in time recovery. But since you do not
have the backup, I exactly can not say a step by step process to recover the
stored procedures,
Thanks
Hari
SQL Server MVP
"Agnes" <agnes@.dynamictech.com.hk> wrote in message
news:%233prORwTFHA.2940@.TK2MSFTNGP10.phx.gbl...
> Backup database ' I didn't do any back up...
> "Pradeep Kutty" <pradeepk@.healthasyst.com>
glsD:eGdPULwTFHA.1152@.tk2msftngp13.phx.gbl...
the
>|||What is CV '
"mark baekdal" <markbaekdal@.discussions.microsoft.com> glsD:F02D1C3C-A912-42A1-A3
8B-5028F1DDEF79@.microsoft.com...
> update your CV.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Build, Comparison and Synchronization from Source Control = Database
> change
> management for SQL Server
>
>
> "Agnes" wrote:
>