The only device checked as 'standard' was 'Master', I unchecked it after
selecting 'EmeraldLog' (200MB)
I'm curious if that was the fault - or one of them :(
Thank's a lot!
-
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 19:03
>An: emerald@emerald.iea.com
>Betreff: Re: AW: %$=A7!@!!! SQL-Server
>
>OK, but it is dependant on what is the default device. If you have a =
500
>MB emerald device and a 50 MB master device and the master is set to be =
the
>default, you will run out of room. You need to set the default segment =
to
>your transaction device and make sure that the master device have =
default
>unchecked.
>
>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: %$=A7!@!!! 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#=3D90368 extent id=3D90488 =
logical
>>>>pg#=3D90488 object id on extent=3D1461580245 (object name =3D =
Traffic) indid
>>>>on extent=3D3
>>>>Allocation Discrepancy: Page is allocated but not linked; check the
>>>>following pages and ids: allocation pg#=3D90368 extent id=3D90488 =
logical
>>>>pg#=3D90489 object id on extent=3D1461580245 (object name =3D =
Traffic) indid
>>>>on extent=3D3
>>>>
>>>>[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=FCr 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=F6=DFe zu erh=F6hen.
>>>>
>>>>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???=20
>>>>
>>>>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
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>