Re: HELP! Lost my server!

Dale E. Reed Jr. ( (no email) )
Fri, 25 Jul 1997 14:45:09 -0700

Will LaSala wrote:
> Hi all,
> Wouldn't fate have it!
> I just upgraded to Radius 2.2 and all of the sudden
> SQL decided that it was going to delete the Master
> Database! Well that means that all my other databases are no longer
> available.

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.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |