RE: Help!! Can't Enter Users

Barry Kiesz ( barry@mdex.net )
Fri, 28 Mar 1997 17:36:30 -0600

------ =_NextPart_000_01BC3B9E.92FCBDC0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Thank s a million, Josh... We're up and running again.

Barry

-----Original Message-----
From: Josh Hillman [SMTP:admin-maillist@talstar.com]
Sent: Friday, March 28, 1997 2:24 PM
To: emerald@emerald.iea.com
Subject: Re: Help!! Can't Enter Users

The message below was originally sent to someone else with the same problem
earlier this morning:

SQL Enterprise Manager
Databases
Emerald (double-click on it)
Truncate the Transaction Log

This will tell you that you should do a diskdump right afterwards, so you
should do that as well
right-click on the Emerald database and choose Backup/Restore
Make sure that Database Backup displays Emerald.
Select a Backup Device (I created one a while back called
"Emerald_diskdump", but you can use the generic "diskdump"
too)
Click on Backup Now. (you may have to click on the Initialize
Device checkbox first)

That should take care of it.

Josh Hillman
hillman@talstar.com

----------
From: Barry Kiesz <barry@mdex.net>
To: 'emerald@emerald.iea.com'
Subject: Help!! Can't Enter Users
Date: Friday, March 28, 1997 3:03 PM

Hello!

Got a quick question, I was able to enter people just fine in Emerald up
until about 20 min ago.. I'm now getting SQL Insert error.

Here is snip from my SQL log. Please help... I am still able to
authenticate, the ability to modify and add records is fried...

--snip---

97/03/28 13:55:28.90 spid17 Can't allocate space for object 'Syslogs' in
database 'Emerald' because the 'logsegment' segment is full. If you ran out
of space in Syslogs, dump the transaction log. Otherwise, use ALTER
DATABASE or sp_extendsegment to increase the size of the segment.

97/03/28 13:55:36.94 spid17 Error : 1105, Severity: 17, State: 2

97/03/28 13:55:36.94 spid17 Can't allocate space for object 'Syslogs' in
database 'Emerald' because the 'logsegment' segment is full. If you ran out
of space in Syslogs, dump the transaction log. Otherwise, use ALTER
DATABASE or sp_extendsegment to increase the size of the segment.

----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
----------

----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com

------ =_NextPart_000_01BC3B9E.92FCBDC0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+Ih8XAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAHQAAAFJFOiBIZWxwISEgQ2Fu
J3QgRW50ZXIgVXNlcnMA2QgBBYADAA4AAADNBwMAHAARACQAHgAFAEsBASCAAwAOAAAAzQcDABwA
EQAhACkABQBTAQEJgAEAIQAAADFGNzQyRDA3QTVBN0QwMTE5OTczMDA0MDMzMzUzRTNFAOEGAQOQ
BgBgCQAAIQAAAAsAAgABAAAACwAjAAAAAAADACYAAAAAAAsAKQAAAAAAAwAuAAAAAAADADYAAAAA
AEAAOQCAhLPc0Du8AR4AcAABAAAAHQAAAFJFOiBIZWxwISEgQ2FuJ3QgRW50ZXIgVXNlcnMAAAAA
AgFxAAEAAAAWAAAAAbw70NyLBy10IKelEdCZcwBAMzU+PgAAHgAeDAEAAAAFAAAAU01UUAAAAAAe
AB8MAQAAAA8AAABiYXJyeUBtZGV4Lm5ldAAAAwAGEEovh8IDAAcQDgcAAB4ACBABAAAAZQAAAFRI
QU5LU0FNSUxMSU9OLEpPU0hXRVJFVVBBTkRSVU5OSU5HQUdBSU5CQVJSWS0tLS0tT1JJR0lOQUxN
RVNTQUdFLS0tLS1GUk9NOkpPU0hISUxMTUFOU01UUDpBRE1JTi1NQUkAAAAAAgEJEAEAAABBBgAA
PQYAAIELAABMWkZ1GV6vz3cACgEDAfcgAqQD4wIAY4JoCsBzZXQwIAcThwKDAFAO9nBycTIP9iZ9
CoAIyCA7CW8yNWY1AoAKgXVjAFALA2MDAEELYG5nMTAzM4kLpiBUD4BuayAEIEhhIG0DEGxpAiAs
QCBKb3NoLhfQIIhXZScJcCB1cBbQwG5kIHJ1bgMAFXB1FtBnC3EuCqIKhAqAQjkKwHJ5GcoK9Bcw
MzZPAUAVEAFAEUBvdAWQdKEQhDE2IC0dkk8FEF5nC4AHQAXQB5BzGWBlPx2TGcYcpBxxCxMcpmkt
GDE0NAFAFzAxODBHAUAM0CEzYiBGA2E6zQyDYg/gF5IgSBcRA4IAW1NNVFA6YWQZFwBuLQDAFxJz
dEAtAZBsJUAKwC4FoG1dPxnFImAGYAIwIscigGlkNGF5F3BNCsAPcCAyQjgXcDE5OTcoYDogMjQg
UE0mN1RvlSLHZQeAcgdAZEAqtRouCJBhJeImOHViaiMc0SLHUmU6I5BlbKBwISEgQwBwJwVA5kUC
MASQIFUPsA+gHz//IEob9Au2GdMWYBhQB4EeopQgYi4Abwfgd2EEIDMFsB4EbHkWsCbRIHT2bxaw
A3BlAiAYUC4AD7D5M4BpdCOANfAYUB6gB4C+IByRAmAqsBnEK8ByFzD/LvE18AQAFvAFsBkSIsAZ
2fhTUUwutBFABAAYUCgQCx4wHsByGcQgIERhXwGRM6AHkDr2O1BFKsQgTChkCGA24S1jFzBjaxag
AiAgNeApPAg7UFT9GOFjO4AYUDYiPyAAcQDQwnQXQSBMb2cZyhZgvzghA/AXIDTALgADIHkIYP82
ETuAQoMXsAhgPPE9MBbRwmQEAGtkdW0YgB3xemgFQGEBgASQM5ALIHN/F3A1AEKCGcRDaELTM6F3
/0JROvZEsz2YNiI8pifAO5T7GJMPcG8XoBhQGoA90Bhwbi8tsCVABbBlOvYoEGv/NkEIcD+SQvE7
dktVRBILUf55BCA8pRm1O1AGYDbwHOBjFtFORURldj3AGFAofklK4AlwP3EYwDVCFuB3/zgQNvAz
IEtxSuA0MQmAPmkqIjylX0QmIhdwYnX3QwQ/YAOgdTWhNiIewDVQvQUQY1RwVRc+aTTQbz5X9kM9
tk5FTjNgF/A9EEKSdwDANGAPgHY/kTTgSNtJ5wMAQGAHQGl6TDc8YVFFyw9wBZBrBuB4ICEAD6D/
PkYyFkLxQ2UBkEzhP2AYQfxvZj4hGbsZxCNaGcRS0fcj0iVqYg8KHZMe6SKDS1EJGqEgSwiQc3og
PJM7sBqhQG0BAHguNVDMdD4yFSoQICcqvyvE/ic5NSzFLe8u/DtxLcEnn/kopDM6FaApSBnTbNEJ
ADdtIDtQGcpHHLAW0XF1/z3Cc2BL4RdDUcAzkgGgUvF3NNEm0S7xcDUwC1AYUGr/VoAFQCEANVEL
gDyXGHAZxP8Y8EBgAyABoAhgBUAWMSShBRlRbxfhSSdtIG7/M2EewAJAGSI5klzQLzEFQL8EkANg
JdBw/BhBOCFzAwC/GIADUhbwNGA5kgkAZxfw/lA28EpyMoBs8BfSdFE2cN8WsHgBeCJ04xnEYVXQ
MoD/d/E/YhdwNiIBoAMQNeA0YP800QRhBpA0YBiiJIAYwQWS/0WQfIIDUAiQK5AX0GXcfMLXHwkZ
4ijQLxWgLyhwKKDHcIAUECkQOC45D+BO0L1vMDEo4FlxbVM0MW8/Y/9O0ADQGFACEAXANtAs4mpA
5Qawc33Rcyd2oRnESie+JzyliwAzMD9gVoYnisL8ZWcHgAIwiwCN1YPTQ5D+bHlRYbBCkkABM8BV
0BnEf2GhiXR2sYqVF3BEYzYidPtACX3TTzYhRVA6QRdwVoIgQUxURVJuVUFUYEFCQVNFM8GH4V//
aUAcwBiwjmY00QuAUeJWlf8AkF1QYZI2I43kGbuGrRwQV4ewKTCH90V7MiBssDH9FZA1F3AGYFug
BRCCEJxR7jecsQGQbtIymV+ab4gP/4kfii+LP4xPjV+Ob49/kI//kZ+Sr5O/lM+V35bvl/+ZD/8d
hLK/s8+03x8WPJcoEIHh/RkxTCUxPsQ+xCUiLzGc8f8rL2ZPYi6yb71Pvl+1n7avX7e/uM8r2hnT
EgEAxQAAAAADABAQAAAAAAMAERAAAAAAAwCAEP////9AAAcwcKUReNA7vAFAAAgwcKUReNA7vAEL
AACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCF
AAAAAAAAAwAFgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAALcNAAADAAmACCAGAAAAAADAAAAAAAAA
RgAAAAABhQAAAAAAAB4AFYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguMAALABmA
CCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAGoAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAA
AAAAAwAcgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeACuACCAGAAAAAADAAAAAAAAARgAA
AAA2hQAAAQAAAAEAAAAAAAAAHgAsgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAA
AB4ALYAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAAeAD0AAQAAAAUAAABSRTog
AAAAAAMADTT9NwAA9qI=

------ =_NextPart_000_01BC3B9E.92FCBDC0--