Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Careless delete all SP
Message
 
 
To
02/05/2005 06:58:08
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01010096
Message ID:
01010099
Views:
27
Try to restore the databese with SP's from backup under different name.

>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 ~~~~
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform