asked on

SQL server stops responding

I am using SQL 7 with service pack 4

the sql server gives this error and terminates the application when application is run again it runs normally

"The MSSQLServer service terminated unexpectedly"

There are also dmp files in the error log folder

i also red the error log but was unable to understand it partially

Error Log

2004-08-20 10:05:23.10 kernel Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)
      Apr 9 2002 14:18:16
      Copyright (c) 1988-2002 Microsoft Corporation
      Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2004-08-20 10:05:23.35 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2004-08-20 10:05:23.35 kernel All rights reserved.
2004-08-20 10:05:23.35 kernel Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2004-08-20 10:05:23.82 kernel initconfig: Number of user connections limited to 32767.
2004-08-20 10:05:23.82 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-08-20 10:05:24.82 kernel User Mode Scheduler configured for thread processing
2004-08-20 10:05:26.60 server Directory Size: 21579
2004-08-20 10:05:26.70 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2004-08-20 10:05:26.70 kernel Attempting to initialize Distributed Transaction Coordinator.
2004-08-20 10:05:29.75 spid1 Starting up database 'master'.
2004-08-20 10:05:29.75 spid1 Opening file C:\MSSQL7\data\master.mdf.
2004-08-20 10:05:30.12 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2004-08-20 10:05:31.50 spid1 Loading SQL Server's Unicode collation.
2004-08-20 10:05:31.84 spid1 Loading SQL Server's non-Unicode sort order and character set.
2004-08-20 10:05:33.03 spid1 5 transactions rolled forward in database 'master' (1).
2004-08-20 10:05:33.10 spid1 0 transactions rolled back in database 'master' (1).
2004-08-20 10:05:33.73 spid1 Starting up database 'model'.
2004-08-20 10:05:33.73 spid1 Opening file C:\MSSQL7\DATA\model.mdf.
2004-08-20 10:05:34.09 spid1 Opening file c:\mssql7\data\modellog.ldf.
2004-08-20 10:05:34.62 spid1 Clearing tempdb database.
2004-08-20 10:05:34.76 spid1 Creating file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-20 10:05:35.14 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-20 10:05:35.18 spid1 Creating file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-20 10:05:35.40 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-20 10:05:35.67 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-20 10:05:35.70 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-20 10:05:36.26 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-20 10:05:36.32 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-20 10:05:36.32 spid1 Starting up database 'tempdb'.
2004-08-20 10:05:36.32 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-20 10:05:36.37 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-20 10:05:36.78 spid1 Server is unnamed.
2004-08-20 10:05:36.79 kernel Using 'SQLEVN70.DLL' version '7.00.1063'.
2004-08-20 10:05:36.79 kernel Using 'OPENDS60.DLL' version '7.00.00.1063'.
2004-08-20 10:05:36.85 ods Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\\.\pipe\sql\query'.
2004-08-20 10:05:36.85 ods Using 'SSMSSO70.DLL' version '7.0.1063' to listen on '1433'.
2004-08-20 10:05:36.85 ods Using 'SSMSRP70.DLL' version '7.0.961' to listen on 'SQLSRV'.
2004-08-20 10:05:36.87 spid6 Starting up database 'msdb'.
2004-08-20 10:05:36.87 spid6 Opening file C:\MSSQL7\DATA\msdbdata.mdf.
2004-08-20 10:05:36.87 spid7 Starting up database 'pubs'.
2004-08-20 10:05:36.87 spid7 Opening file C:\MSSQL7\DATA\pubs.mdf.
2004-08-20 10:05:36.87 spid8 Starting up database 'Northwind'.
2004-08-20 10:05:36.87 spid8 Opening file C:\MSSQL7\DATA\northwnd.mdf.
2004-08-20 10:05:36.92 spid9 Starting up database 'ILMDeFineS'.
2004-08-20 10:05:36.92 spid9 Opening file C:\MSSQL7\data\ILMDeFineS.mdf.
2004-08-20 10:05:37.31 spid6 Opening file c:\mssql7\DATA\msdblog.ldf.
2004-08-20 10:05:37.31 spid7 Opening file c:\mssql7\DATA\pubs_log.ldf.
2004-08-20 10:05:37.32 spid8 Opening file C:\MSSQL7\DATA\northwnd.ldf.
2004-08-20 10:05:37.53 spid9 Opening file C:\MSSQL7\data\ILMDefines_log.ldf.
2004-08-20 10:05:38.40 spid7 Starting up database 'usermanagement'.
2004-08-20 10:05:38.40 spid7 Opening file C:\mssql7\data\usermanagement.mdf.
2004-08-20 10:05:39.40 spid7 Opening file C:\mssql7\data\usermanagement_log.ldf.
2004-08-20 10:05:39.59 spid6 27 transactions rolled forward in database 'msdb' (4).
2004-08-20 10:05:40.21 spid6 0 transactions rolled back in database 'msdb' (4).
2004-08-20 10:05:46.04 spid9 472 transactions rolled forward in database 'ILMDeFineS' (7).
2004-08-20 10:05:46.04 spid9 0 transactions rolled back in database 'ILMDeFineS' (7).
2004-08-20 10:05:46.54 spid1 Recovery complete.
2004-08-20 10:05:46.54 spid1 SQL Server's Unicode collation is:
2004-08-20 10:05:46.54 spid1 'English' (ID = 1033).
2004-08-20 10:05:46.54 spid1 comparison style = 196609.
2004-08-20 10:05:46.54 spid1 SQL Server's non-Unicode sort order is:
2004-08-20 10:05:46.54 spid1 'nocase_iso' (ID = 52).
2004-08-20 10:05:46.54 spid1 SQL Server's non-Unicode character set is:
2004-08-20 10:05:46.54 spid1 'iso_1' (ID = 1).
2004-08-20 10:05:51.89 spid7 Using 'xpsqlbot.dll' version '1998.11.13' to execute extended stored procedure 'xp_qv'.
2004-08-20 10:06:40.96 spid13 Using 'xpstar.dll' version '2000.28.09' to execute extended stored procedure 'sp_MSgetversion'.
2004-08-20 10:55:55.25 spid23 Using 'xpsql70.dll' version '2000.28.09' to execute extended stored procedure 'xp_msver'.
2004-08-20 13:30:03.48 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1146:1, last LSN: 9:1148:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408201330.TRN'}).
2004-08-20 13:30:25.95 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19677, first LSN: 80123:452:1, last LSN: 80123:454:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408201330.BAK'}).
2004-08-20 13:30:34.43 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1148:1, last LSN: 9:1150:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408201330.BAK'}).
2004-08-20 15:58:56.28 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19684, first LSN: 80126:39:1, last LSN: 80126:47:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\SanaAttackAug-20-2004'}).
2004-08-20 18:36:18.65 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19788, first LSN: 80133:234:1, last LSN: 80133:236:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'D:\SanaAttackAug-20-2004'}).
2004-08-21 00:00:01.69 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1148:1, last LSN: 9:1150:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\usermanagement\usermanagement_tlog_200408210000.TRN'}).
2004-08-21 01:00:21.08 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19907, first LSN: 80219:573:1, last LSN: 80219:575:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\ILMDeFineS\ILMDeFineS_db_200408210100.BAK'}).
2004-08-21 01:00:29.15 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1150:1, last LSN: 9:1152:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\usermanagement\usermanagement_db_200408210100.BAK'}).
2004-08-21 11:55:37.65 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19906, first LSN: 80219:652:1, last LSN: 80219:654:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\12 After Noon'}).
2004-08-21 11:57:41.35 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1152:1, last LSN: 9:1154:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\12-00 PM User'}).
2004-08-21 13:30:01.07 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1150:1, last LSN: 9:1154:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408211330.TRN'}).
2004-08-21 13:30:23.35 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19902, first LSN: 80222:235:1, last LSN: 80222:243:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408211330.BAK'}).
2004-08-21 13:30:32.44 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1154:1, last LSN: 9:1156:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408211330.BAK'}).
2004-08-21 18:00:00.95 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1154:1, last LSN: 9:1156:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_tlog_200408211800.TRN'}).
2004-08-21 18:00:23.67 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19900, first LSN: 80235:16:1, last LSN: 80235:18:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408211800.BAK'}).
2004-08-21 18:00:32.42 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1156:1, last LSN: 9:1158:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408211800.BAK'}).
2004-08-22 00:00:00.69 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1156:1, last LSN: 9:1158:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\usermanagement\usermanagement_tlog_200408220000.TRN'}).
2004-08-22 01:00:20.76 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19900, first LSN: 80235:18:1, last LSN: 80235:20:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\ILMDeFineS\ILMDeFineS_db_200408220100.BAK'}).
2004-08-22 01:00:28.64 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1158:1, last LSN: 9:1160:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\usermanagement\usermanagement_db_200408220100.BAK'}).
2004-08-22 13:30:01.43 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1158:1, last LSN: 9:1160:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408221330.TRN'}).
2004-08-22 13:30:22.32 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19901, first LSN: 80235:20:1, last LSN: 80235:22:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408221330.BAK'}).
2004-08-22 13:30:30.49 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1160:1, last LSN: 9:1162:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408221330.BAK'}).
2004-08-22 18:00:01.14 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1160:1, last LSN: 9:1162:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_tlog_200408221800.TRN'}).
2004-08-22 18:00:23.00 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19901, first LSN: 80235:22:1, last LSN: 80235:24:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408221800.BAK'}).
2004-08-22 18:00:31.59 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1162:1, last LSN: 9:1164:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408221800.BAK'}).
2004-08-23 00:00:00.97 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1162:1, last LSN: 9:1164:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\usermanagement\usermanagement_tlog_200408230000.TRN'}).
2004-08-23 01:00:20.80 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19901, first LSN: 80235:24:1, last LSN: 80235:26:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\ILMDeFineS\ILMDeFineS_db_200408230100.BAK'}).
2004-08-23 01:00:29.36 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1164:1, last LSN: 9:1166:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\MID Night Backup\usermanagement\usermanagement_db_200408230100.BAK'}).
2004-08-23 11:55:03.85 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 19918, first LSN: 80243:283:1, last LSN: 80243:318:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'D:\Makhdoom 23-08-2004'}).
2004-08-23 12:20:09.78 spid3 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:\MSSQL7\log\SQL00037.dmp
2004-08-23 12:20:13.67 spid3 Error: 0, Severity: 19, State: 0
2004-08-23 12:20:13.67 spid3 SqlDumpExceptionHandler: Process 3 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
.
*******************************************************************************
*
* BEGIN STACK DUMP:
* 08/23/04 12:20:13 spid 3
*
* Exception Address = 00000000
* Exception Code = c0000005 E
* Access Violation occurred reading address 00000000
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 008d2fff 004d3000
* ntdll 77f80000 77ffafff 0007b000
* KERNEL32 7c4e0000 7c598fff 000b9000
* ADVAPI32 7c2d0000 7c331fff 00062000
* RPCRT4 77d30000 77da0fff 00071000
* USER32 77e10000 77e74fff 00065000
* GDI32 77f40000 77f7bfff 0003c000
* ole32 77a50000 77b46fff 000f7000
* OLEAUT32 779b0000 77a4afff 0009b000
* VERSION 77820000 77826fff 00007000
* LZ32 759b0000 759b5fff 00006000
* opends60 41060000 41085fff 00026000
* ums 41090000 4109cfff 0000d000
* MSVCRT 78000000 78044fff 00045000
* sqlsort 04000000 0408efff 0008f000
* MSVCIRT 780a0000 780b1fff 00012000
* sqlevn70 410a0000 410a6fff 00007000
* COMNEVNT 410b0000 410fefff 0004f000
* ODBC32 1f7d0000 1f803fff 00034000
* comdlg32 76b30000 76b6dfff 0003e000
* SHLWAPI 77c70000 77cb9fff 0004a000
* COMCTL32 77b50000 77bd8fff 00089000
* SHELL32 782f0000 78537fff 00248000
* SQLWOA 41100000 4110bfff 0000c000
* odbcint 00fb0000 00fc5fff 00016000
* NDDEAPI 769a0000 769a6fff 00007000
* WINSPOOL 77800000 7781dfff 0001e000
* MPR 76620000 76630fff 00011000
* SQLTrace 41130000 4117dfff 0004e000
* NETAPI32 75170000 751befff 0004f000
* SECUR32 7c340000 7c34efff 0000f000
* NETRAP 751c0000 751c5fff 00006000
* SAMLIB 75150000 7515efff 0000f000
* WS2_32 75030000 75043fff 00014000
* WS2HELP 75020000 75027fff 00008000
* WLDAP32 77950000 77979fff 0002a000
* DNSAPI 77980000 779a3fff 00024000
* WSOCK32 75050000 75057fff 00008000
* SSNMPN70 41190000 41195fff 00006000
* SSMSSO70 411a0000 411aafff 0000b000
* SSMSRP70 411b0000 411b7fff 00008000
* XOLEHLP 65450000 65457fff 00008000
* MSDTCPRX 6df80000 6e033fff 000b4000
* MTXCLU 6a7a0000 6a7affff 00010000
* CLUSAPI 73930000 7393ffff 00010000
* RESUTILS 689d0000 689dcfff 0000d000
* USERENV 7c0f0000 7c151fff 00062000
* rnr20 782c0000 782cbfff 0000c000
* iphlpapi 77340000 77352fff 00013000
* ICMP 77520000 77524fff 00005000
* MPRAPI 77320000 77336fff 00017000
* ACTIVEDS 773b0000 773defff 0002f000
* ADSLDPC 77380000 773a2fff 00023000
* RTUTILS 77830000 7783dfff 0000e000
* SETUPAPI 77880000 7790dfff 0008e000
* RASAPI32 774e0000 77512fff 00033000
* RASMAN 774c0000 774d0fff 00011000
* TAPI32 77530000 77551fff 00022000
* DHCPCSVC 77360000 77378fff 00019000
* winrnr 777e0000 777e7fff 00008000
* rasadhlp 777f0000 777f4fff 00005000
* msafd 74fd0000 74fedfff 0001e000
* wshtcpip 75010000 75016fff 00007000
* mswsock 74ff0000 75001fff 00012000
* SQLRGSTR 411c0000 411c4fff 00005000
* xpsqlbot 41820000 41825fff 00006000
* sqlboot 417f0000 417f7fff 00008000
* xpstar 411d0000 41200fff 00031000
* SQLWID 412f0000 412f5fff 00006000
* SQLSVC 415e0000 415f8fff 00019000
* odbcbcp 41220000 41225fff 00006000
* SQLRESLD 41320000 41325fff 00006000
* W95SCM 41210000 41217fff 00008000
* SQLSVC 42480000 42485fff 00006000
* xpsql70 41380000 4138afff 0000b000
* sqlimage 72a00000 72a2cfff 0002d000
*
* Edi: 31D7A780: 31d7a028 31e8cfc0 31d7a83c 007a1354 00000000 007a12b8
* Esi: 0044EE6A: c0855900 00009886 8bfffbce d9e82876 ff59fffb cee2e857
* Eax: 31E8D67C: 31d7b220 00000000 00000001 31d7ab54 00000001 0079f2b8
* Ebx: 00000001:
* Ecx: 31E8D67C: 31d7b220 00000000 00000001 31d7ab54 00000001 0079f2b8
* Edx: 31E8DFF4: 31a38000 00000000 31820028 00000000 31e8ce78 00000c41
* Eip: 00000000:
* Ebp: 3F9AFBBC: 00000001 00456379 3f9afbe8 31d7a474 0044ee03 3f9afbc8
* SegCs: 0000001B:
* EFlags: 00010246: 00540041 00500000 004e004e 00490042 005c0037 004c0051
* Esp: 3F9AFBA0: 00791ff2 3f9afbdc 31d7a780 31d7a780 00000001 31d7a780
* SegSs: 00000023:
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x00000000 Module(sqlservr+ffc00000)
0x31d7a780 Module(UNKNOWN+0)
0x0044ee03 Module(sqlservr+4ee03) (CQuery::`vector deleting destructor'+b)
0x00456379 Module(sqlservr+56379) (CStmtQuery::~CStmtQuery+28)
0x0045633d Module(sqlservr+5633d) (CStmtDML::`vector deleting destructor'+b)
0x00438662 Module(sqlservr+38662) (CCompPlan::~CCompPlan+34)
0x0043861a Module(sqlservr+3861a) (CCompPlan::`vector deleting destructor'+b)
0x00436d7d Module(sqlservr+36d7d) (CCacheObject::Release+b4)
0x005fea06 Module(sqlservr+1fea06) (CCache::FRemoveOne+172)
0x005a5641 Module(sqlservr+1a5641) (BPool::DoSomeLazyWrites+29a)
0x004cae2d Module(sqlservr+cae2d) (BPool::LazyWriter+1de)
0x004cad4b Module(sqlservr+cad4b) (lazywriter+f5)
0x41092cff Module(ums+2cff) (ProcessWorkRequests+102)
0x41093523 Module(ums+3523) (ThreadStartRoutine+139)
0x78008454 Module(MSVCRT+8454) (endthread+c1)
0x7c4e987c Module(KERNEL32+987c) (SetThreadExecutionState+227)
-------------------------------------------------------------------------------
2004-08-23 12:20:14.08 kernel LazyWriter: Process 3 generated an access violation. SQL Server is terminating this process.

AustinSeven

Should have been fixed by SP4 - see the following link. Check the attributes of sqlsort.dll as below.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314117

NOTE: The following hotfix was created prior to Microsoft SQL Server 7.0 Service Pack 4.

The English version of this fix should have the following file attributes or later:
Date Time Version Size File name
---------------------------------------------------------------

2001-12-02 10:41 PM 7.00.1016 5,054,736 KB Sqlservr.exe
2001-01-14 12:39 AM 7.00.0978 586,000 KB Sqlsort.dll

AustinSeven

Wild_Cat

ASKER

same specs

so what should i doo

Wild_Cat

ASKER

Dear AustinSeven
i was waiting for your answer should i send another error log
the problem is still there and the sql server is with service pack 4
if u suggest i should reinstall the server.
or just uninstall sql and reinstall it

AustinSeven

Sorry, missed that one. Sorry again because I can't resolve you're problem. You problems should have been fixed with SP4. You could try re-applying the service pack but that's a long shot. Failing that...

http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a

AustinSeven

Mike Reynolds

No idea if this fix will apply to you but I had a similar problem with SQL Server 2000.
Eventually resolved by installing MDAC 2.8?

Like I said, I don't use SQL Server 7 so perhaps this does not apply?

Wild_Cat

ASKER

right what i did was i increased the minimum memory for sql server from 1024 to 2048 :) and the disconection was solved

Wild_Cat

ASKER

so now the game is about dump files

Wild_Cat

ASKER

ok one day no error the second day

these errors were in the windows evant viewer
>>>>
The MSSQLServer service terminated unexpectedly. It has done this 8 time(s). The following corrective action will be taken in 0 milliseconds: No action.

The MSSQLServer service terminated unexpectedly. It has done this 7 time(s). The following corrective action will be taken in 0 milliseconds: No action.

The description for Event ID ( 2001 ) in Source ( rasctrs ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: The event log file is corrupt..
>>>>>>>>>>
and sql error log

2004-08-28 11:23:43.85 kernel Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)
      Apr 9 2002 14:18:16
      Copyright (c) 1988-2002 Microsoft Corporation
      Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2004-08-28 11:23:43.85 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2004-08-28 11:23:43.85 kernel All rights reserved.
2004-08-28 11:23:43.85 kernel Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2004-08-28 11:23:43.86 kernel initconfig: Number of user connections limited to 32767.
2004-08-28 11:23:43.86 kernel SQL Server is starting at priority class 'high'(1 CPU detected).
2004-08-28 11:23:43.88 kernel User Mode Scheduler configured for thread processing
2004-08-28 11:23:44.88 server Directory Size: 21579
2004-08-28 11:23:44.88 spid1 Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2004-08-28 11:23:44.88 kernel Attempting to initialize Distributed Transaction Coordinator.
2004-08-28 11:23:46.93 spid1 Starting up database 'master'.
2004-08-28 11:23:46.93 spid1 Opening file C:\MSSQL7\data\master.mdf.
2004-08-28 11:23:46.93 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2004-08-28 11:23:47.02 spid1 Loading SQL Server's Unicode collation.
2004-08-28 11:23:47.04 spid1 Loading SQL Server's non-Unicode sort order and character set.
2004-08-28 11:23:47.18 spid1 2 transactions rolled forward in database 'master' (1).
2004-08-28 11:23:47.18 spid1 0 transactions rolled back in database 'master' (1).
2004-08-28 11:23:47.24 spid1 Starting up database 'model'.
2004-08-28 11:23:47.24 spid1 Opening file C:\MSSQL7\DATA\model.mdf.
2004-08-28 11:23:47.25 spid1 Opening file c:\mssql7\data\modellog.ldf.
2004-08-28 11:23:47.32 spid1 Clearing tempdb database.
2004-08-28 11:23:47.39 spid1 Creating file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-28 11:23:47.41 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-28 11:23:47.50 spid1 Creating file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-28 11:23:47.52 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-28 11:23:47.61 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-28 11:23:47.63 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-28 11:23:47.80 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-28 11:23:47.88 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-28 11:23:47.94 spid1 Starting up database 'tempdb'.
2004-08-28 11:23:47.94 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2004-08-28 11:23:47.96 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2004-08-28 11:23:48.10 spid1 Server is unnamed.
2004-08-28 11:23:48.10 kernel Using 'SQLEVN70.DLL' version '7.00.1063'.
2004-08-28 11:23:48.10 kernel Using 'OPENDS60.DLL' version '7.00.00.1063'.
2004-08-28 11:23:48.10 ods Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\\.\pipe\sql\query'.
2004-08-28 11:23:48.10 ods Using 'SSMSSO70.DLL' version '7.0.1063' to listen on '1433'.
2004-08-28 11:23:48.10 ods Using 'SSMSRP70.DLL' version '7.0.961' to listen on 'SQLSRV'.
2004-08-28 11:23:48.11 spid6 Starting up database 'msdb'.
2004-08-28 11:23:48.11 spid6 Opening file C:\MSSQL7\DATA\msdbdata.mdf.
2004-08-28 11:23:48.11 spid7 Starting up database 'pubs'.
2004-08-28 11:23:48.13 spid7 Opening file C:\MSSQL7\DATA\pubs.mdf.
2004-08-28 11:23:48.13 spid8 Starting up database 'Northwind'.
2004-08-28 11:23:48.13 spid8 Opening file C:\MSSQL7\DATA\northwnd.mdf.
2004-08-28 11:23:48.13 spid9 Starting up database 'ILMDeFineS'.
2004-08-28 11:23:48.13 spid9 Opening file C:\MSSQL7\data\ILMDeFineS.mdf.
2004-08-28 11:23:48.24 spid6 Opening file c:\mssql7\DATA\msdblog.ldf.
2004-08-28 11:23:48.29 spid9 Opening file C:\MSSQL7\data\ILMDefines_log.ldf.
2004-08-28 11:23:48.30 spid7 Opening file c:\mssql7\DATA\pubs_log.ldf.
2004-08-28 11:23:48.32 spid8 Opening file C:\MSSQL7\DATA\northwnd.ldf.
2004-08-28 11:23:48.94 spid6 2 transactions rolled forward in database 'msdb' (4).
2004-08-28 11:23:48.94 spid7 Starting up database 'usermanagement'.
2004-08-28 11:23:48.94 spid7 Opening file C:\mssql7\data\usermanagement.mdf.
2004-08-28 11:23:48.99 spid6 0 transactions rolled back in database 'msdb' (4).
2004-08-28 11:23:49.04 spid7 Opening file C:\mssql7\data\usermanagement_log.ldf.
2004-08-28 11:23:50.61 spid9 82 transactions rolled forward in database 'ILMDeFineS' (7).
2004-08-28 11:23:50.61 spid9 0 transactions rolled back in database 'ILMDeFineS' (7).
2004-08-28 11:23:51.19 spid1 Recovery complete.
2004-08-28 11:23:51.21 spid1 SQL Server's Unicode collation is:
2004-08-28 11:23:51.21 spid1 'English' (ID = 1033).
2004-08-28 11:23:51.21 spid1 comparison style = 196609.
2004-08-28 11:23:51.21 spid1 SQL Server's non-Unicode sort order is:
2004-08-28 11:23:51.21 spid1 'nocase_iso' (ID = 52).
2004-08-28 11:23:51.21 spid1 SQL Server's non-Unicode character set is:
2004-08-28 11:23:51.21 spid1 'iso_1' (ID = 1).
2004-08-28 13:30:02.25 spid12 Using 'xpstar.dll' version '2000.28.09' to execute extended stored procedure 'xp_sqlmaint'.
2004-08-28 13:30:05.05 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1186:1, last LSN: 9:1188:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408281330.BAK'}).
2004-08-28 13:30:14.66 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1186:1, last LSN: 9:1188:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408281330.TRN'}).
2004-08-28 13:30:21.66 kernel BackupMedium::ReportIoError: write failure on backup device 'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408281330.BAK'. Operating system error 112(There is not enough space on the disk.).
2004-08-28 17:22:08.01 kernel BackupMedium::ReportIoError: write failure on backup device 'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408281722.BAK'. Operating system error 112(There is not enough space on the disk.).
2004-08-28 17:22:09.41 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1188:1, last LSN: 9:1190:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408281722.BAK'}).
2004-08-28 18:00:00.68 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1188:1, last LSN: 9:1190:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_tlog_200408281800.TRN'}).
2004-08-29 13:30:01.11 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1190:1, last LSN: 9:1190:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408291330.TRN'}).
2004-08-29 13:30:07.38 kernel BackupMedium::ReportIoError: write failure on backup device 'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408291330.BAK'. Operating system error 112(There is not enough space on the disk.).
2004-08-29 13:30:08.96 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1190:1, last LSN: 9:1192:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408291330.BAK'}).
2004-08-29 17:22:06.40 kernel BackupMedium::ReportIoError: write failure on backup device 'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408291722.BAK'. Operating system error 112(There is not enough space on the disk.).
2004-08-29 17:22:07.73 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1192:1, last LSN: 9:1194:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408291722.BAK'}).
2004-08-29 18:00:00.89 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1190:1, last LSN: 9:1194:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_tlog_200408291800.TRN'}).
2004-08-30 13:30:01.51 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1194:1, last LSN: 9:1194:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408301330.TRN'}).
2004-08-30 13:30:07.94 kernel BackupMedium::ReportIoError: write failure on backup device 'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408301330.BAK'. Operating system error 112(There is not enough space on the disk.).
2004-08-30 13:30:09.39 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1194:1, last LSN: 9:1196:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408301330.BAK'}).
2004-08-30 17:22:06.00 kernel BackupMedium::ReportIoError: write failure on backup device 'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408301722.BAK'. Operating system error 112(There is not enough space on the disk.).
2004-08-30 17:22:07.28 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1196:1, last LSN: 9:1198:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408301722.BAK'}).
2004-08-30 18:00:01.30 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1194:1, last LSN: 9:1198:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_tlog_200408301800.TRN'}).
2004-08-30 18:04:23.05 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 20508, first LSN: 80931:508:1, last LSN: 80931:510:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408301804.BAK'}).
2004-08-30 18:04:32.89 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1198:1, last LSN: 9:1200:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408301804.BAK'}).
2004-08-31 13:30:00.77 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1198:1, last LSN: 9:1200:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_tlog_200408311330.TRN'}).
2004-08-31 13:30:25.55 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 20531, first LSN: 80947:253:1, last LSN: 80947:255:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\ILMDeFineS\ILMDeFineS_db_200408311330.BAK'}).
2004-08-31 13:30:36.11 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1200:1, last LSN: 9:1202:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\1 pm Backup\usermanagement\usermanagement_db_200408311330.BAK'}).
2004-08-31 18:00:03.29 backup Log backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), first LSN: 9:1200:1, last LSN: 9:1202:1, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_tlog_200408311800.TRN'}).
2004-08-31 18:04:25.69 backup Database backed up with following information: Database: ILMDeFineS, creation date and time: 2004/08/19(15:46:17), pages dumped: 20531, first LSN: 80961:277:1, last LSN: 80961:279:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\ILMDeFineS\ILMDeFineS_db_200408311804.BAK'}).
2004-08-31 18:04:36.27 backup Database backed up with following information: Database: usermanagement, creation date and time: 2004/03/29(00:52:38), pages dumped: 237, first LSN: 9:1202:1, last LSN: 9:1204:1, sort order: 52, striped: 0, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'E:\DEFINES\usermanagement\usermanagement_db_200408311804.BAK'}).

Wild_Cat

ASKER

Exactly when this happens the sql server goes down
i have installed mdac 2.8 still have problems

now i have some more research the process in the sql server increases and all of them are also in lock processes ?????

Opening file C:\mssql7\data\usermanagement.mdf.
2004-08-28 11:23:48.99 spid6 0 transactions rolled back in database 'msdb' (4).
2004-08-28 11:23:49.04 spid7 Opening file C:\mssql7\data\usermanagement_log.ldf.
2004-08-28 11:23:50.61 spid9 82 transactions rolled forward in database 'ILMDeFineS' (7).
2004-08-28 11:23:50.61 spid9 0 transactions rolled back in database 'ILMDeFineS' (7).
2004-08-28 11:23:51.19 spid1 Recovery complete.
2004-08-28 11:23:51.21 spid1 SQL Server's Unicode collation is:
2004-08-28 11:23:51.21 spid1 'English' (ID = 1033).
2004-08-28 11:23:51.21 spid1 comparison style = 196609.
2004-08-28 11:23:51.21 spid1 SQL Server's non-Unicode sort order is:
2004-08-28 11:23:51.21 spid1 'nocase_iso' (ID = 52).
2004-08-28 11:23:51.21 spid1 SQL Server's non-Unicode character set is:
2004-08-28 11:23:51.21 spid1 'iso_1' (ID = 1).
2004-08-28 13:30:02.25 spid12 Using 'xpstar.dll' version '2000.28.09' to execute extended stored procedure 'xp_sqlmaint'.

suddenly u people have stopped responding .................... !

ASKER CERTIFIED SOLUTION

AustinSeven

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial