I have no idea how your master.dat could have been deleted,
especially if SQL Server was running (since it is in use).
> Well that means the Emerald Database with all my customers information
> is gone. I checked the Hard Drive and found that the files
> Emerald.Dat and EmeraldLog.Dat are still there so all is not lost!
> I just have no clue on how to make SQL Server see those DAT files
> again.
You can't. The master.dat is like the FAT portion of a drive. It
tells SQL Server where the other files are and whats in them.
Without it, your emerald.dat file is just a bunch of binary
junk. Hopefully you had a dump of your database.
I had a somewhere lengthy post last month on this subject. You
might want to check the archives for it.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com