Re: [Emerald] SQL server crashed twice in 2 days

Dale E. Reed Jr. ( (no email) )
Sat, 29 May 1999 21:21:58 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: david leigh: "[Emerald] SQL server crashed twice in 2 days"
Next message: David Moore: "Fw: Fw: [Emerald] radusers"
Maybe in reply to: david leigh: "[Emerald] SQL server crashed twice in 2 days"

david leigh wrote:
>
> Hi All
>
> After months of rock solid operation our SQL server (6.5) has now crashed
> twice in the last two days - its running Emerald 2.5.261
>
> On the most recent occassion it spat out two gigabytes of error logs with
> one line being repeated literally billions of times.
>
> 99/05/3 00:00.13.27 (and numerous times per every hundredth of a second)
> spid2 bufdiscard: WARNING, page 21067 (dbid 6, bp 0x1253b80) has
> stat0x1000/0 (), skipping
>
> Does anyone have any ideas about this? I'm beginning to get very nervous
> about the stability of my box, and I'm losing precious beauty sleep :(

I would recommend copying the data out to another SQL Server
or database and then dropping/re-creating the database. There is
probably an inconsitency in the database that is causing problems.

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

Previous message: david leigh: "[Emerald] SQL server crashed twice in 2 days"
Next message: David Moore: "Fw: Fw: [Emerald] radusers"
Maybe in reply to: david leigh: "[Emerald] SQL server crashed twice in 2 days"