At 06:02 PM 2/26/97 +0100, you wrote:
>Sorry, I should have added that there is a data-device of 800MB and a
>logdevice of 200MB.
>-
>Peter A. Sang
>SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
>T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
>* Microsoft Solution Provider * Intel Systems Integrator *
>
>>----------
>>Von: Gecker@Oakweb.com[SMTP:Gecker@Oakweb.com]
>>Gesendet: Mittwoch, 26. Februar 1997 17:12
>>An: emerald@emerald.iea.com
>>Betreff: Re: %$§!@!!! SQL-Server
>>
>>Well I don't know about the first one. But the second one sounds like you
>>have your master device or emerald device set as the default for your
>>transaction log. You should create a separate device for the log and set
>>the new device you created to be the default. I'm no SQL wizard, but give
>>that a try.
>>
>>
>>At 03:59 PM 2/26/97 +0100, you wrote:
>>>Hi Folks, today _I_ have to ask two of these stupid SQL questions :(
>>>
>>>1. This is from the log of our SQLMAINT.EXE process:
>>>Allocation Discrepancy: Page is allocated but not linked; check the
>>>following pages and ids: allocation pg#=90368 extent id=90488 logical
>>>pg#=90488 object id on extent=1461580245 (object name = Traffic) indid
>>>on extent=3
>>>Allocation Discrepancy: Page is allocated but not linked; check the
>>>following pages and ids: allocation pg#=90368 extent id=90488 logical
>>>pg#=90489 object id on extent=1461580245 (object name = Traffic) indid
>>>on extent=3
>>>
>>>[and so on for about 10.000 (!) page numbers]
>>>
>>>What does it mean, and how do I fix it?? DBCC CHECKDB gives me no errors
>>>at all, everything looks fine.
>>>
>>>2. This is from our error.log file:
>>>97/02/26 06:39:53.06 spid11 Fehler: 1105, Schweregrad: 17, Zustand: 1
>>>97/02/26 06:39:53.06 spid11 Kann für Objekt 'MSProxyLog' in Datenbank
>>>'Emerald' keinen Speicher reservieren, da 'default' Segment voll ist. In
>>>Syslogs kann durch Speichern des Protokolls Platz geschaffen werden.
>>>Sonst ALTER DATABASE oder sp_extendsegment verwenden, um die
>>>Segmentgröße zu erhöhen.
>>>
>>>For those not German-challenged: Cannot allocate space for Object 'xxx'
>>>in db 'yyyy' because the 'default' segment is full .....
>>>
>>>The db has a size of 1GB, used space is around 500 MB. What does
>>>'default-segment' mean _exactly_? What am I missing???? How do I fix
>>>it???
>>>
>>>Lot's of questions...do you have the right answers???
>>>
>>>cu, Peter
>>>-
>>>Peter A. Sang
>>>SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
>>>T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
>>>* Microsoft Solution Provider * Intel Systems Integrator *
>>>
>>> ----------------------------------------------------------
>>> Emerald Mailing List listserver@emerald.iea.com
>>>
>>>
>>David Edwards
>>System Administrator - Oakweb.com
>>Lake Tahoe's Premier Internet Service Provider
>>1-800-61-TAHOE
>>
>> ----------------------------------------------------------
>> Emerald Mailing List listserver@emerald.iea.com
>>
>>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>
David Edwards
System Administrator - Oakweb.com
Lake Tahoe's Premier Internet Service Provider
1-800-61-TAHOE