У нас на фирме используется СУБД SQL Server 7.0 (SP2).
Она имеет размер 16 Gb. Интенсивно работающих пользователей ~30.
При больших запросах или при возрастании загрузки происходит
самопроизвольная остановка сервера с ошибкой

Severity Level 20: SQL Server Fatal Error in Current Process

Как можно побороть эту проблему?

Настройки сервера

name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask 0 2147483647 0 0
allow updates 0 1 0 0
cost threshold for parallelism 0 32767 5 5
cursor threshold -1 2147483647 -1 -1
default language 0 9999 21 21
default sortorder id 0 255 106 106
extended memory size (MB) 0 2147483647 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 1600000 0 0
language in cache 3 100 3 3
language neutral full-text 0 1 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max async IO 1 255 32 32
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 1800 1800
max text repl size (B) 0 2147483647 65536 65536
max worker threads 10 1024 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 1800 1800
nested triggers 0 1 1 1
network packet size (B) 512 65535 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 5 5
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 0 0
resource timeout (s) 5 2147483647 10 10
scan for startup procs 0 1 1 1
set working set size 0 1 0 0
show advanced options 0 1 1 1
spin counter 1 2147483647 10000 10000
time slice (ms) 50 1000 100 100
two digit year cutoff 1753 9999 2049 2049
Unicode comparison style 0 2147483647 196609 196609
Unicode locale id 0 2147483647 1033 1033
user connections 0 32767 0 0
user options 0 4095 0 0

========================================================================================
ErrorLog
========================================================================================
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server 1792.842
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is AT/AT COMPATIBLE.
Bios Version is sONSKA4 PhoenixBIOS SKA4 Production Release 50.1
PhoenixBIOS 4.0 Release 6.0
Current local time is Wed Apr 10 10:01:06 2002
4 Intel x86 level 6, 697 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD .


Memory
------
MemoryLoad = 97% TotalPhys = 2047 MB AvailPhys = 50 MB
TotalPageFile = 3431 MB

Dump thread - spid = 23, PSS = 0x75e0d0e0, EC = 0x74098084
Stack Dump being sent to j:\sqlsystem\log\SQL00119.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 04/10/02 10:01:06 spid 23
*
* Input Buffer 88 bytes -
* e x e c v p _ R e s t A l c o h o l S u b j s 0 , " 1 2 . 0 3 . 2
* 0 0 2 " , 9 , 0
*
*******************************************************************************

Забыл указать ключевую строку ErrorLog

2002-04-10 10:00:58.13 spid23 Process 23 unlocking unowned resource: KEY: 8:50099219:5 (d00084c8eb73)
2002-04-10 10:00:58.15 spid23 Process 23 unlocking unowned resource: KEY: 8:50099219:5 (d00084c8eb73)
2002-04-10 10:00:58.15 spid23 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 23, PSS = 0x75e0d0e0, EC = 0x74098084
Stack Dump being sent to j:\sqlsystem\log\SQL00118.dmp

Как видно из STACK DUMP сбой в данном конкретном случае произошел на
процедуре v p _ R e s t A l c o h o l S u b j s. Но в жизни сбои происходят
на любой процедуре, которая делает массированные вычисления.

Решил привести весь Log файл:


2002-04-08 16:30:30.73 kernel Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: )

2002-04-08 16:30:30.73 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2002-04-08 16:30:30.73 kernel All rights reserved.
2002-04-08 16:30:30.73 kernel Logging SQL Server messages in file 'j:\sqlsystem\log\ERRORLOG'.
2002-04-08 16:30:30.73 kernel initconfig: Number of user connections limited to 32767.
2002-04-08 16:30:30.73 kernel SQL Server is starting at priority class 'normal'(4 CPUs detected).
2002-04-08 16:30:30.77 kernel User Mode Scheduler configured for thread processing
2002-04-08 16:30:34.98 server Directory Size: 74163
2002-04-08 16:30:35.00 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2002-04-08 16:30:35.00 kernel Attempting to initialize Distributed Transaction Coordinator.
2002-04-08 16:30:35.03 spid1 Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2002-04-08 16:30:35.03 spid1 Starting up database 'master'.
2002-04-08 16:30:35.03 spid1 Opening file j:\sqlsystem\data\master.mdf.
2002-04-08 16:30:35.03 spid1 Opening file j:\sqlsystem\data\mastlog.ldf.
2002-04-08 16:30:35.09 spid1 Loading SQL Server's Unicode collation.
2002-04-08 16:30:35.11 spid1 Loading SQL Server's non-Unicode sort order and character set.
2002-04-08 16:30:35.14 spid1 2 transactions rolled forward in database 'master' (1).
2002-04-08 16:30:35.16 spid1 0 transactions rolled back in database 'master' (1).
2002-04-08 16:30:35.17 spid1 Starting up database 'model'.
2002-04-08 16:30:35.17 spid1 Opening file j:\sqlsystem\DATA\model.mdf.
2002-04-08 16:30:35.19 spid1 Opening file j:\sqlsystem\DATA\modellog.ldf.
2002-04-08 16:30:35.23 spid1 Clearing tempdb database.
2002-04-08 16:30:35.25 spid1 Creating file j:\sqlsystem\DATA\TEMPDB.MDF.
2002-04-08 16:30:35.27 spid1 Closing file j:\sqlsystem\DATA\TEMPDB.MDF.
2002-04-08 16:30:35.27 spid1 Creating file j:\sqlsystem\DATA\TEMPLOG.LDF.
2002-04-08 16:30:35.27 spid1 Closing file j:\sqlsystem\DATA\TEMPLOG.LDF.
2002-04-08 16:30:35.28 spid1 Opening file j:\sqlsystem\DATA\TEMPDB.MDF.
2002-04-08 16:30:35.28 spid1 Opening file j:\sqlsystem\DATA\TEMPLOG.LDF.
2002-04-08 16:30:35.33 spid1 Closing file j:\sqlsystem\DATA\TEMPDB.MDF.
2002-04-08 16:30:35.33 spid1 Closing file j:\sqlsystem\DATA\TEMPLOG.LDF.
2002-04-08 16:30:35.33 spid1 Starting up database 'tempdb'.
2002-04-08 16:30:35.33 spid1 Opening file j:\sqlsystem\DATA\TEMPDB.MDF.
2002-04-08 16:30:35.33 spid1 Opening file j:\sqlsystem\DATA\TEMPLOG.LDF.
2002-04-08 16:30:35.38 spid1 Server name is 'KOA'.
2002-04-08 16:30:35.38 kernel Using 'SQLEVN70.DLL' version '7.00.842'.
2002-04-08 16:30:35.38 kernel Using 'OPENDS60.DLL' version '7.00.00.0839'.
2002-04-08 16:30:35.38 ods Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\.\pipe\sql\query'.
2002-04-08 16:30:35.38 ods Using 'SSMSSO70.DLL' version '7.0.694' to listen on '1433'.
2002-04-08 16:30:35.39 ods Using 'SSMSRP70.DLL' version '7.0.839' to listen on 'KOA'.
2002-04-08 16:30:35.41 spid6 Starting up database 'msdb'.
2002-04-08 16:30:35.41 spid6 Opening file j:\sqlsystem\DATA\msdbdata.mdf.
2002-04-08 16:30:35.41 spid7 Starting up database 'pubs'.
2002-04-08 16:30:35.41 spid7 Opening file j:\sqlsystem\DATA\pubs.mdf.
2002-04-08 16:30:35.41 spid8 Starting up database 'Northwind'.
2002-04-08 16:30:35.41 spid8 Opening file j:\sqlsystem\DATA\northwnd.mdf.
2002-04-08 16:30:35.41 spid9 Starting up database 'WorkLog'.
2002-04-08 16:30:35.41 spid9 Opening file F:\SQLArchive\WorkLog_Data.MDF.
2002-04-08 16:30:35.41 spid10 Starting up database 'orta310'.
2002-04-08 16:30:35.41 spid10 Opening file E:\SQLData\Orta_Data.Mdf.
2002-04-08 16:30:35.44 spid6 Opening file j:\sqlsystem\DATA\msdblog.ldf.
2002-04-08 16:30:35.44 spid7 Opening file j:\sqlsystem\DATA\pubs_log.ldf.
2002-04-08 16:30:35.44 spid8 Opening file j:\sqlsystem\DATA\northwnd.ldf.
2002-04-08 16:30:35.45 spid9 Opening file I:\SQLLog\WorkLog_Log.LDF.
2002-04-08 16:30:35.45 spid10 Opening file F:\SQLArchive\Orta_Arj.ndf.
2002-04-08 16:30:35.47 spid10 Opening file G:\SQLMove\Orta_Move.ndf.
2002-04-08 16:30:35.48 spid10 Opening file H:\SQLWorkLog\Orta_WLg.ndf.
2002-04-08 16:30:35.50 spid10 Opening file I:\SQLLog\Orta_Log.Ldf.
2002-04-08 16:30:35.50 spid10 Opening file K:\SQLTLog\OrtaLog2_Log.LDF.
2002-04-08 16:30:35.69 spid6 11 transactions rolled forward in database 'msdb' (4).
2002-04-08 16:30:35.73 spid6 0 transactions rolled back in database 'msdb' (4).
2002-04-08 16:30:37.45 spid10 Recovery progress on database 'orta310' (: 16 percent.
2002-04-08 16:30:39.66 spid10 Recovery progress on database 'orta310' (: 33 percent.
2002-04-08 16:30:45.81 spid10 Recovery progress on database 'orta310' (: 50 percent.
2002-04-08 16:30:46.95 spid10 Recovery progress on database 'orta310' (: 66 percent.
2002-04-08 16:30:48.03 spid10 Recovery progress on database 'orta310' (: 83 percent.
2002-04-08 16:30:49.78 spid10 2155 transactions rolled forward in database 'orta310' (.
2002-04-08 16:30:49.78 spid10 Recovery progress on database 'orta310' (: 100 percent.
2002-04-08 16:30:49.88 spid10 0 transactions rolled back in database 'orta310' (.
2002-04-08 16:31:03.89 spid1 Recovery complete.
2002-04-08 16:31:03.89 spid1 SQL Server's Unicode collation is:
2002-04-08 16:31:03.89 spid1 'English' (ID = 1033).
2002-04-08 16:31:03.89 spid1 comparison style = 196609.
2002-04-08 16:31:03.89 spid1 SQL Server's non-Unicode sort order is:
2002-04-08 16:31:03.89 spid1 'nocase_1251' (ID = 106).
2002-04-08 16:31:03.89 spid1 SQL Server's non-Unicode character set is:
2002-04-08 16:31:03.89 spid1 'cp1251' (ID = 5).
2002-04-08 16:31:03.91 spid1 Launched startup procedure 'xp_startmail'
2002-04-08 16:31:03.95 spid9 Using 'sqlmap70.dll' version '1998.11.13' to execute extended stored procedure 'xp_startmail'.
2002-04-08 16:31:03.95 ods Starting SQL Mail session...
2002-04-08 16:31:41.45 ods SQL Mail session started.
2002-04-08 16:31:51.52 spid9 Using 'xpstar.dll' version '2000.02.08' to execute extended stored procedure 'sp_MSgetversion'.
2002-04-08 16:31:55.27 spid14 Using 'xpsqlbot.dll' version '1998.11.13' to execute extended stored procedure 'xp_qv'.
2002-04-08 17:00:14.53 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159169:3306:1, last LSN: 159179:6845:1, striped: 0, number of dump devices: 1, device information: (FILE=16, TYPE=DISK: {'OrtaLogDump'}).
2002-04-08 18:00:08.33 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159179:6845:1, last LSN: 159190:384:1, striped: 0, number of dump devices: 1, device information: (FILE=17, TYPE=DISK: {'OrtaLogDump'}).
2002-04-08 19:00:14.72 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159190:384:1, last LSN: 159283:77:1, striped: 0, number of dump devices: 1, device information: (FILE=18, TYPE=DISK: {'OrtaLogDump'}).
2002-04-08 20:00:13.86 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159283:77:1, last LSN: 159385:2165:1, striped: 0, number of dump devices: 1, device information: (FILE=19, TYPE=DISK: {'OrtaLogDump'}).
2002-04-08 21:00:09.53 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159385:2165:1, last LSN: 159425:3732:1, striped: 0, number of dump devices: 1, device information: (FILE=20, TYPE=DISK: {'OrtaLogDump'}).
2002-04-08 22:00:08.40 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159425:3732:1, last LSN: 159504:102:1, striped: 0, number of dump devices: 1, device information: (FILE=21, TYPE=DISK: {'OrtaLogDump'}).
2002-04-08 23:00:09.75 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159504:102:1, last LSN: 159594:4547:1, striped: 0, number of dump devices: 1, device information: (FILE=22, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 02:00:01.88 backup Database backed up with following information: Database: master, creation date and time: 2002/04/08(16:30:35), pages dumped: 1250, first LSN: 109:130:1, last LSN: 109:132:1, sort order: 106, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'MasterDump'}).
2002-04-09 02:00:04.52 backup Database backed up with following information: Database: msdb, creation date and time: 2001/01/26(16:31:50), pages dumped: 1723, first LSN: 422:151:3, last LSN: 422:153:1, sort order: 106, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'MsdbDump'}).
2002-04-09 02:07:19.42 backup Database backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), pages dumped: 1628997, first LSN: 159715:630:5, last LSN: 159718:541:1, sort order: 106, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'OrtaDataDump'}).
2002-04-09 02:07:33.01 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159594:4547:1, last LSN: 159718:566:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 03:00:11.48 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159718:566:1, last LSN: 159756:5164:1, striped: 0, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 04:00:08.56 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159756:5164:1, last LSN: 159779:184:1, striped: 0, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 05:00:07.18 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159779:184:1, last LSN: 159800:3512:1, striped: 0, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 06:00:10.71 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159800:3512:1, last LSN: 159810:2327:1, striped: 0, number of dump devices: 1, device information: (FILE=5, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 07:00:07.60 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159810:2327:1, last LSN: 159826:1124:1, striped: 0, number of dump devices: 1, device information: (FILE=6, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 08:00:03.34 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159826:1124:1, last LSN: 159834:6709:1, striped: 0, number of dump devices: 1, device information: (FILE=7, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 09:00:07.22 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159834:6709:1, last LSN: 159838:4029:1, striped: 0, number of dump devices: 1, device information: (FILE=8, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 10:00:09.96 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159838:4029:1, last LSN: 159847:2777:1, striped: 0, number of dump devices: 1, device information: (FILE=9, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 11:00:10.10 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159847:2777:1, last LSN: 159857:4343:1, striped: 0, number of dump devices: 1, device information: (FILE=10, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 12:00:09.57 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159857:4343:1, last LSN: 159889:495:1, striped: 0, number of dump devices: 1, device information: (FILE=11, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 13:00:15.33 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159889:495:1, last LSN: 159924:1716:1, striped: 0, number of dump devices: 1, device information: (FILE=12, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 14:00:05.95 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159924:1716:1, last LSN: 159947:1214:1, striped: 0, number of dump devices: 1, device information: (FILE=13, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 15:00:05.93 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159947:1214:1, last LSN: 159972:1417:1, striped: 0, number of dump devices: 1, device information: (FILE=14, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 16:00:04.10 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 159972:1417:1, last LSN: 160026:3403:1, striped: 0, number of dump devices: 1, device information: (FILE=15, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 17:00:13.38 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160026:3403:1, last LSN: 160042:5821:1, striped: 0, number of dump devices: 1, device information: (FILE=16, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 18:00:06.54 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160042:5821:1, last LSN: 160063:4481:1, striped: 0, number of dump devices: 1, device information: (FILE=17, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 19:00:06.64 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160063:4481:1, last LSN: 160080:1176:1, striped: 0, number of dump devices: 1, device information: (FILE=18, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 20:00:10.68 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160080:1176:1, last LSN: 160157:906:1, striped: 0, number of dump devices: 1, device information: (FILE=19, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 21:00:14.83 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160157:906:1, last LSN: 160260:2081:1, striped: 0, number of dump devices: 1, device information: (FILE=20, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 22:00:06.43 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160260:2081:1, last LSN: 160314:410:1, striped: 0, number of dump devices: 1, device information: (FILE=21, TYPE=DISK: {'OrtaLogDump'}).
2002-04-09 23:00:05.56 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160314:410:1, last LSN: 160376:279:1, striped: 0, number of dump devices: 1, device information: (FILE=22, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 01:02:58.43 spid9 DBCC CHECKDB (orta310) executed by GREY\OrtaAgent found 0 errors and repaired 0 errors.
2002-04-10 01:03:11.52 spid9 DBCC CHECKALLOC (orta310) executed by GREY\OrtaAgent found 0 errors and repaired 0 errors.
2002-04-10 02:00:02.19 backup Database backed up with following information: Database: master, creation date and time: 2002/04/08(16:30:35), pages dumped: 1250, first LSN: 109:132:1, last LSN: 109:134:1, sort order: 106, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'MasterDump'}).
2002-04-10 02:00:04.75 backup Database backed up with following information: Database: msdb, creation date and time: 2001/01/26(16:31:50), pages dumped: 1723, first LSN: 423:136:3, last LSN: 423:138:1, sort order: 106, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'MsdbDump'}).
2002-04-10 02:07:27.91 backup Database backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), pages dumped: 1638533, first LSN: 160470:1876:4, last LSN: 160470:2517:1, sort order: 106, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'OrtaDataDump'}).
2002-04-10 02:07:34.33 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160376:279:1, last LSN: 160470:2549:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 03:00:05.49 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160470:2549:1, last LSN: 160480:426:1, striped: 0, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 04:00:03.36 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160480:426:1, last LSN: 160481:2706:1, striped: 0, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 05:00:06.21 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160481:2706:1, last LSN: 160490:611:1, striped: 0, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 06:00:02.16 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160490:611:1, last LSN: 160495:7231:1, striped: 0, number of dump devices: 1, device information: (FILE=5, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 07:00:05.10 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160495:7231:1, last LSN: 160498:1964:1, striped: 0, number of dump devices: 1, device information: (FILE=6, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 08:00:02.45 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160498:1964:1, last LSN: 160502:656:1, striped: 0, number of dump devices: 1, device information: (FILE=7, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 09:00:01.47 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160502:656:1, last LSN: 160508:4206:1, striped: 0, number of dump devices: 1, device information: (FILE=8, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 10:00:09.44 backup Log backed up with following information: Database: orta310, creation date and time: 2001/02/04(00:12:49), first LSN: 160508:4206:1, last LSN: 160560:344:1, striped: 0, number of dump devices: 1, device information: (FILE=9, TYPE=DISK: {'OrtaLogDump'}).
2002-04-10 10:00:58.13 spid23 Process 23 unlocking unowned resource: KEY: 8:50099219:5 (d00084c8eb73)
2002-04-10 10:00:58.15 spid23 Process 23 unlocking unowned resource: KEY: 8:50099219:5 (d00084c8eb73)
2002-04-10 10:00:58.15 spid23 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 23, PSS = 0x75e0d0e0, EC = 0x74098084
Stack Dump being sent to j:\sqlsystem\log\SQL00118.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 04/10/02 10:01:02 spid 23
*
* Input Buffer 88 bytes -
* e x e c v p _ R e s t A l c o h o l S u b j s 0 , " 1 2 . 0 3 . 2
* 0 0 2 " , 9 , 0
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f97ac6 Module(ntdll+17ac6) (NtGetContextThread+b)
0x00784f83 Module(sqlservr+384f83) (utassert_fail+19f)
0x005b572c Module(sqlservr+1b572c) (ExecutionContext::Cleanup+9d)
0x004eb421 Module(sqlservr+eb421) (ExecutionContext::Purge+45)
0x004eb182 Module(sqlservr+eb182) (stopsubprocess+e5)
0x004e9d4e Module(sqlservr+e9d4e) (subproc_main+174)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+13
0x7800bea1 Module(MSVCRT+bea1) (beginthread+ce)
0x77e92ca8 Module(KERNEL32+12ca (CreateFileA+11b)
2002-04-10 10:01:02.69 kernel SQL Server Assertion: File: <proc.c>, line=1927
Failed Assertion = 'm_activeSdesList.Head () == NULL'.
2002-04-10 10:01:02.69 spid23 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 23, PSS = 0x75e0d0e0, EC = 0x74098084
Stack Dump being sent to j:\sqlsystem\log\SQL00119.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 04/10/02 10:01:06 spid 23
*
* Input Buffer 88 bytes -
* e x e c v p _ R e s t A l c o h o l S u b j s 0 , " 1 2 . 0 3 . 2
* 0 0 2 " , 9 , 0
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f97ac6 Module(ntdll+17ac6) (NtGetContextThread+b)
0x0077b371 Module(sqlservr+37b371) (ex_raise2+35b)
0x0077b3dd Module(sqlservr+37b3dd) (ex_raise+5f)
0x00784f16 Module(sqlservr+384f16) (utassert_fail+37d)
0x005b572c Module(sqlservr+1b572c) (ExecutionContext::Cleanup+9d)
0x004eb421 Module(sqlservr+eb421) (ExecutionContext::Purge+45)
0x004eb182 Module(sqlservr+eb182) (stopsubprocess+e5)
0x004e9d4e Module(sqlservr+e9d4e) (subproc_main+174)
0x41092a47 Module(ums+2a47) (ProcessWorkRequests+ec)
0x4109326b Module(ums+326b) (ThreadStartRoutine+13
0x7800bea1 Module(MSVCRT+bea1) (beginthread+ce)
0x77e92ca8 Module(KERNEL32+12ca (CreateFileA+11b)
2002-04-10 10:01:06.30 spid23 Error: 1203, Severity: 20, State: 1
2002-04-10 10:01:06.30 spid23 Process ID 23 attempting to unlock unowned resource KEY: 8:50099219:5 (d00084c8eb73)..
2002-04-10 10:01:06.32 spid23 Error: 1203, Severity: 20, State: 1
2002-04-10 10:01:06.32 spid23 Process ID 23 attempting to unlock unowned resource KEY: 8:50099219:5 (d00084c8eb73)..
2002-04-10 10:01:06.46 ods Stopped SQL Mail session.

Для Jimmers. Огромное спасибо. Это действительно наш случай.
Займемся скачиванием и установкой SP3 for MS SQL Server 7.0.