Thanks all for your help...
Franco
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Laslo Orto
Sent: Tuesday, November 24, 1998 4:49 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Big Mistake!
backup the .dat files
create new devices using same (or new) names
create a db using the new devices
stop sql server and overwrite the new .dat files with the old ones
start sql and you should have a working db
i pulled it off once so it should work.
At 03:00 PM 11/24/98 -0700, you wrote:
>Hi, Someone here goofed up, probably me, we are not sure, but they dropped
a
>database, and deleted the device, from SQL enterprise manager
>
>The actual DAT files are still there and most likely are intact, can I put
>it back together ? Can I reuse the exact device files and make my database
>come back to life?
>I have a VERY recent script to rebuild the database (Without the data) but
I
>REALLY need the data and there is no backup.
>
>Franco
>
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
>
--------------------
Laslo Orto
Systems Administrator
Creative People On-Line
1200 Sheppard Ave. East, Suite 404
Toronto, Canada M2K 2S5
Tel: 416-492-0321x258
Fax: 416-492-2090
mailto:laslo@cpol.com
http://www.cpol.com
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html