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:
>