RE: [Emerald] SQL Server having problems!

Christian Lawrence ( (no email) )
Fri, 4 Jun 1999 16:43:22 -0500

Go into Emerald client and view who is logged on and then clear them.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Darin Spence
Sent: Friday, June 04, 1999 5:43 AM
To: emerald@iea-software.com
Subject: RE: [Emerald] SQL Server having problems!

To make things worse, now the system isn't logging people out. I.E. If
they log in, log out, then try to call in again later, the system shows that
they are already logged in and doesn't let them in.

Any ideas?

^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Darin Spence
darin@radio-inc.com
Director of Information Technology > R A D I O, INC
(785) 628-1064, ext. 22 > Phone
http://www.media-net.net

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Darin Spence
> Sent: Friday, June 04, 1999 3:23 AM
> To: emerald@iea-software.com
> Subject: [Emerald] SQL Server having problems!
>
>
> Sheryl had helped me remove a Platypus installation months ago.
>
> In investigating my space problem, I just noticed in the e:\mssql\data\
> directory there is a file called PlatDevice.DAT that is 2GB
> Big!!! There is
> also a PlatLog.DAT that is 512MB big!!!
>
> We are having all kinds of problems trying to save incidents
> because it says
> the database is full or something. Does anyone have any idea if the
> PlatDevice.DAT and PlatLog.DAT can be deleted? Will that FREAK
> OUT the SQL
> Server? I check my Devices and Databases and they are no where
> to be found
> through Enterprise Mgr. (I think I looked in the right places, maybe not).
>
> *help*
>
> ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Darin Spence
> darin@radio-inc.com
> Director of Information Technology > R A D I O, INC
> (785) 628-1064, ext. 22 > Phone
> http://www.media-net.net
>
> > -----Original Message-----
> > From: emerald-request@iea-software.com
> > [mailto:emerald-request@iea-software.com]On Behalf Of Darin Spence
> > Sent: Friday, June 04, 1999 2:39 AM
> > To: emerald@iea-software.com
> > Subject: RE: [Emerald] Re: HElp
> >
> >
> > Our SQL database is spitting out an error whenever we try to save
> > incidents
> > saying that we are out of space. How do we increase? We have
> > TONS of Hard
> > Drive space...
> >
> > Also, my Application Log keeps filling up with the following error:
> >
> > Getting this error in my application log in SQL:
> > Error: 1105, Severity. 17 State:1
> > Can't allocate space for object 'Calls' in database 'Emerald'
> because the
> > 'default' segment is full. If you ran out of space in Syslogs, dump the
> > transaction log. Otherwisee, use ALTER DATABASE or sp_extendsegment to
> > increate the size of the segment.
> >
> > What do I do?!?
> >
> > ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Darin Spence
> > darin@radio-inc.com
> > Director of Information Technology > R A D I O, INC
> > (785) 628-1064, ext. 22 > Phone
> > http://www.media-net.net
> >
> > > -----Original Message-----
> > > From: emerald-request@iea-software.com
> > > [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> > > Sent: Friday, June 04, 1999 9:26 AM
> > > To: emerald@iea-software.com
> > > Subject: Re: [Emerald] Re: HElp
> > >
> > >
> > > Darin Spence wrote:
> > > >
> > > > So before rebooting an SQL server, one should stop the service,
> > > then reboot?
> > >
> > > Under heavy load, SQL Server may not be able to orderly shut down in
> > > time before NT says "Die, you, DIE!". In that case, your
> database will
> > > be in a recovery mode when you restart SQL Server. If you manually
> > > stop SQL Server before rebooting (and wait for it to stop), then you
> > > are guranteed an orderly shutdown and can avoid the recovery issue.
> > >
> > > --
> > >
> > > Dale E. Reed Jr. Emerald and RadiusNT
> > > __________________________________________
> > > IEA Software, Inc. www.iea-software.com
> > >
> >
> >
>
>