I know this is to late, but there is a wizard with SQL 6.5 that will set up
a nightly db check & backup data dump. Set this up for both the Emerald db
& the Master. It saved me twice.
JOhn :}
> From: Will LaSala <will@greennet.net>
> To: emerald@emerald.iea.com
> Subject: Re: HELP! Lost my server!
> Date: Friday, July 25, 1997 4:15 PM
>
> Nope the Master Database is definitely not there!
> I'm actually to the point where I must rebuild the master DB
> ICK!!
> Thanks Will
>
> -----Original Message-----
> From: Josh Hillman <admin-maillist@talstar.com>
> To: emerald@emerald.iea.com <emerald@emerald.iea.com>
> Date: Friday, July 25, 1997 5:10 PM
> Subject: Re: HELP! Lost my server!
>
>
>
> >> From: Will LaSala <will@greennet.net>
> >> 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.
> >> 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.
> >> Any help would be greatly appreciated!
> >
> >This is going to sound a little strange, but are you sure it wasn't a
> >problem with too many logins into the db? I only ask because that
happened
> >to me this morning--it said there were 15 logins and the only thing
> >accessing the db at the time was Radius! I had to stop Radius and
> >MSSQLServer, then restart them before I was able to get back into
Emerald,
> >ISQL/w. The weird thing thing was that our web-based IDC script was
> >pulling information on current callers as if there was nothing wrong.
> >Strange.
> >
> >Josh Hillman
> >hillman@talstar.com
>
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers!
608.742.1601 & 6980 2800 New Pinery Road, Suite 10
http://www.palacenet.net/ Portage, WI 53901
http://www.microt.com/
--- __o
--- _-\<,_ FASTEST SERVICE IN TOWN
--- (_)/ (_)
----------