Re: [Emerald] Big Mistake!

Laslo Orto ( )
Tue, 24 Nov 1998 18:48:34 -0500

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.
>For more information about this list, including removal,
>please see

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