Event ID 7031
in [Server Configuration]
|
From: Alberto on 7 Jul 2010 08:18 Dear ALL, we are just experiencing a sort of nightmare since we start migrating database (SQL Server 2000 Ent. SP4 on a Win 2000 AS SP4) from a Compaq Proliant 5500 2 nodes Cluster to a Virtual Machine (VMware ESX 4.0) maintaining Win2000 SP4 and SQL Server 2000 Ent SP4 Before migrating machines, every processing was so slow but each one went good, now we got random system restart and /or SQL Server restart. In the previous environment we only had 512 MB RAM but now 8GB !!!! In the sql log and event viewer there are many records but I think most of them are result of SQL Server restart. Just an example is event ID 7031 without anything in sql log. Is that caused by virtual machine? Is that a menory management issue? Any suggest will be well-appreciated. Regards Alberto
From: Erland Sommarskog on 7 Jul 2010 17:01 Alberto (assistenza(a)adb.it) writes: > we are just experiencing a sort of nightmare since we start migrating > database (SQL Server 2000 Ent. SP4 on a Win 2000 AS SP4) from a Compaq > Proliant 5500 2 nodes Cluster to a Virtual Machine (VMware ESX 4.0) > maintaining Win2000 SP4 and SQL Server 2000 Ent SP4 > > > Before migrating machines, every processing was so slow but each one went > good, now we got random system restart and /or SQL Server restart. > > In the previous environment we only had 512 MB RAM but now 8GB !!!! > > In the sql log and event viewer there are many records but I think most of > them are result of SQL Server restart. > > Just an example is event ID 7031 without anything in sql log. > > Is that caused by virtual machine? > > Is that a menory management issue? > > Any suggest will be well-appreciated. There is no information in the post that makes it possible to make any diagnosis what the root cause might be. If there are lot of rows in the SQL Server errorlog, then it is not unlikely that they have something to do with the error. The startup phase is only the first 100 lines or so. When you say "system restart", do you mean that Windows crashes and starts? In such case, I would assume that the problem is not related to SQL Server as such. You talk about the "sql log", but is that the SQL Server errorlog? There is no error 7031 in sysmessages. If I am to make any guess, your machine has a bad memory board. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: Alberto on 8 Jul 2010 09:29 Hi, as you can read below, there is a sql server error log of last failure. I would have other 2 questions: in previous system we had -T9059 into startup, and now we have tried with and without but no differences seems to be relevant. Windows 2000 AS starts with /PAE because we have 6 GB memory, but SQL runs just 2048 MB (without awe) beause we just don't need; so should we enable awe ? Many thanks in advance Alberto 2010-07-07 10:44:23.13 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 2010-07-07 10:44:23.15 server Copyright (C) 1988-2002 Microsoft Corporation. 2010-07-07 10:44:23.15 server All rights reserved. 2010-07-07 10:44:23.15 server Server Process ID is 720. 2010-07-07 10:44:23.15 server Logging SQL Server messages in file 'e:\program files\microsoft sql server\mssql\data\MSSQL\log\ERRORLOG'. 2010-07-07 10:44:23.29 server SQL Server is starting at priority class 'normal'(2 CPUs detected). 2010-07-07 10:44:23.65 server SQL Server configured for thread mode processing. 2010-07-07 10:44:23.72 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2010-07-07 10:44:24.05 server Attempting to initialize Distributed Transaction Coordinator. 2010-07-07 10:44:26.57 spid2 Starting up database 'master'. 2010-07-07 10:44:26.86 server Using 'SSNETLIB.DLL' version '8.0.2039'. 2010-07-07 10:44:26.86 spid5 Starting up database 'model'. 2010-07-07 10:44:26.90 spid2 Server name is 'SQLCLU'. 2010-07-07 10:44:26.99 spid5 Clearing tempdb database. 2010-07-07 10:44:27.00 spid8 Starting up database 'msdb'. 2010-07-07 10:44:27.00 spid9 Starting up database 'pubs'. 2010-07-07 10:44:27.00 spid10 Starting up database 'Northwind'. 2010-07-07 10:44:27.00 spid11 Starting up database 'adb'. 2010-07-07 10:44:27.02 spid12 Starting up database 'ADBUser'. 2010-07-07 10:44:27.02 spid13 Starting up database 'MERCATI'. 2010-07-07 10:44:27.02 spid14 Starting up database 'netweb'. 2010-07-07 10:44:27.02 spid15 Starting up database 'pettiti'. 2010-07-07 10:44:27.11 spid9 Starting up database 'Procedure'. 2010-07-07 10:44:27.11 spid10 Starting up database 'VarDatabse'. 2010-07-07 10:44:27.25 spid11 Starting up database 'vardb'. 2010-07-07 10:44:27.66 spid5 Starting up database 'tempdb'. 2010-07-07 10:44:27.66 spid8 Starting up database 'MERCATI2'. 2010-07-07 10:44:27.72 server SQL server listening on 192.168.0.2: 1433. 2010-07-07 10:44:27.72 server SQL server listening on 127.0.0.1: 1433. 2010-07-07 10:44:27.91 spid13 Analysis of database 'MERCATI' (9) is 100% complete (approximately 0 more seconds) 2010-07-07 10:44:27.88 spid14 Recovery is checkpointing database 'netweb' (10) 2010-07-07 10:44:28.02 server SQL server listening on TCP, Shared Memory, Named Pipes. 2010-07-07 10:44:28.04 server SQL Server is ready for client connections 2010-07-07 10:44:29.07 spid10 Recovery is checkpointing database 'VarDatabse' (13) 2010-07-07 10:44:29.85 spid8 Analysis of database 'MERCATI2' (15) is 100% complete (approximately 0 more seconds) 2010-07-07 10:44:30.85 spid2 Recovery complete. 2010-07-07 10:44:30.85 spid2 SQL global counter collection task is created. 2010-07-07 10:44:31.93 spid52 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'. 2010-07-07 10:44:48.79 spid56 Using 'xplog70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_cmdshell'. 2010-07-07 10:44:59.93 spid58 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'. 2010-07-07 11:00:08.24 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42262:799241:1, last LSN: 42262:863338:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK04'}). 2010-07-07 11:00:09.19 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:99319:1, last LSN: 24136:102624:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK04'}). 2010-07-07 11:00:09.54 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8077:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK04'}). 2010-07-07 11:00:10.44 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412425:2898:1, last LSN: 412425:3358:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK04'}). 2010-07-07 11:00:10.91 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK04] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK04] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKUP 2010-07-07 11:00:11.16 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK04] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK04] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKUP 2010-07-07 12:00:08.44 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42262:863338:1, last LSN: 42262:866132:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK05'}). 2010-07-07 12:00:08.74 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:102624:1, last LSN: 24136:105981:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK05'}). 2010-07-07 12:00:08.79 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK05'}). 2010-07-07 12:00:09.04 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412425:3358:1, last LSN: 412425:3550:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK05'}). 2010-07-07 12:00:09.07 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK05] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK05] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKUP 2010-07-07 12:00:09.16 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK05] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK05] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKUP 2010-07-07 12:34:44.40 spid63 Using 'sqlmap70.dll' version '2000.80.2039' to execute extended stored procedure 'xp_get_mapi_profiles'. 2010-07-07 12:36:41.85 spid63 Error: 15457, Severity: 0, State: 1 2010-07-07 12:36:41.85 spid63 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. 2010-07-07 13:00:07.83 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42262:866132:1, last LSN: 42262:908098:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK06'}). 2010-07-07 13:00:08.85 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:105981:1, last LSN: 24136:109310:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK06'}). 2010-07-07 13:00:09.10 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK06'}). 2010-07-07 13:00:09.65 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412425:3550:1, last LSN: 412425:3705:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK06'}). 2010-07-07 13:00:09.80 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK06] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK06] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 13:00:10.15 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK06] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK06] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 13:10:06.27 spid55 Process ID 71 killed by hostname CASSANDRA, host process ID 4100. 2010-07-07 14:00:06.96 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42262:908098:1, last LSN: 42262:951272:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK07'}). 2010-07-07 14:00:07.25 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:109310:1, last LSN: 24136:112597:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK07'}). 2010-07-07 14:00:07.35 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK07'}). 2010-07-07 14:00:07.80 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412425:3705:1, last LSN: 412425:3850:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK07'}). 2010-07-07 14:00:07.86 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK07] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK07] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 14:00:08.02 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK07] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK07] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 14:20:09.96 spid64 DBCC TRACEON 208, server process ID (SPID) 64. 2010-07-07 14:20:10.44 spid68 DBCC TRACEON 208, server process ID (SPID) 68. 2010-07-07 14:21:07.97 spid64 DBCC TRACEON 208, server process ID (SPID) 64. 2010-07-07 15:00:08.30 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42262:951272:1, last LSN: 42263:6316:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK08'}). 2010-07-07 15:00:08.58 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:112597:1, last LSN: 24136:115869:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK08'}). 2010-07-07 15:00:08.66 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK08'}). 2010-07-07 15:00:10.19 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412425:3850:1, last LSN: 412435:7873:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK08'}). 2010-07-07 15:00:10.29 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK08] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK08] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 15:00:10.49 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK08] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK08] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 16:00:08.41 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:6316:1, last LSN: 42263:237172:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK09'}). 2010-07-07 16:00:08.62 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:115869:1, last LSN: 24136:119233:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK09'}). 2010-07-07 16:00:08.69 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK09'}). 2010-07-07 16:00:09.04 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412435:7873:1, last LSN: 412435:8123:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK09'}). 2010-07-07 16:00:09.10 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK09] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK09] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 16:00:09.21 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK09] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK09] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 17:00:08.93 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:237172:1, last LSN: 42263:260470:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK10'}). 2010-07-07 17:00:09.10 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:119233:1, last LSN: 24136:122537:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK10'}). 2010-07-07 17:00:09.15 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8090:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK10'}). 2010-07-07 17:00:09.41 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412435:8123:1, last LSN: 412435:8298:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK10'}). 2010-07-07 17:00:09.49 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK10] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK10] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKUP 2010-07-07 17:00:09.63 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK10] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK10] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKUP 2010-07-07 18:00:07.82 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:260470:1, last LSN: 42263:314853:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK11'}). 2010-07-07 18:00:07.96 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:122537:1, last LSN: 24136:126364:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK11'}). 2010-07-07 18:00:08.08 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8090:1, last LSN: 77:8096:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK11'}). 2010-07-07 18:00:08.50 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412435:8298:1, last LSN: 412435:8729:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK11'}). 2010-07-07 18:00:08.66 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK11] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK11] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 18:00:08.77 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK11] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK11] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 19:00:14.75 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:314853:1, last LSN: 42263:411783:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK12'}). 2010-07-07 19:00:16.79 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24136:126364:1, last LSN: 24137:1823:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK12'}). 2010-07-07 19:00:17.07 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8096:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK12'}). 2010-07-07 19:00:17.68 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412435:8729:1, last LSN: 412435:8930:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK12'}). 2010-07-07 19:00:17.80 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK12] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK12] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 19:00:17.96 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK12] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK12] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 20:00:11.90 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:411783:1, last LSN: 42263:562051:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK13'}). 2010-07-07 20:00:13.82 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24137:1823:1, last LSN: 24137:5129:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK13'}). 2010-07-07 20:00:14.40 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8119:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK13'}). 2010-07-07 20:00:15.35 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412435:8930:1, last LSN: 412436:77:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK13'}). 2010-07-07 20:00:15.47 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK13] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK13] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 20:00:15.58 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK13] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK13] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 21:00:10.10 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:562051:1, last LSN: 42263:576361:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK14'}). 2010-07-07 21:00:10.35 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24137:5129:1, last LSN: 24137:8436:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK14'}). 2010-07-07 21:00:10.40 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8119:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK14'}). 2010-07-07 21:00:10.72 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412436:77:1, last LSN: 412436:200:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK14'}). 2010-07-07 21:00:10.79 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK14] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK14] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 21:00:10.91 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK14] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK14] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 22:00:09.82 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:576361:1, last LSN: 42263:602676:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK15'}). 2010-07-07 22:00:10.04 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24137:8436:1, last LSN: 24137:11736:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK15'}). 2010-07-07 22:00:10.10 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8119:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK15'}). 2010-07-07 22:00:10.33 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412436:200:1, last LSN: 412436:290:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK15'}). 2010-07-07 22:00:10.38 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK15] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK15] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 22:00:10.47 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK15] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK15] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 23:00:13.66 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:602676:1, last LSN: 42263:675385:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK16'}). 2010-07-07 23:00:13.93 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24137:11736:1, last LSN: 24137:15020:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK16'}). 2010-07-07 23:00:14.08 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8119:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK16'}). 2010-07-07 23:00:14.63 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412436:290:1, last LSN: 412436:398:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK16'}). 2010-07-07 23:00:14.65 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK16] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK16] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-07 23:00:14.79 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK16] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK16] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-08 00:00:06.77 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:675385:1, last LSN: 42263:726351:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK17'}). 2010-07-08 00:00:06.99 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24137:15020:1, last LSN: 24137:18361:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK17'}). 2010-07-08 00:00:07.05 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8119:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK17'}). 2010-07-08 00:00:07.46 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412436:398:1, last LSN: 412437:18:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK17'}). 2010-07-08 00:00:07.52 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK17] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK17] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-08 00:00:07.68 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK17] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK17] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-08 01:00:06.41 backup Log backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), first LSN: 42263:726351:1, last LSN: 42263:737759:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK18'}). 2010-07-08 01:00:06.66 backup Log backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), first LSN: 24137:18361:1, last LSN: 24137:21680:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK18'}). 2010-07-08 01:00:06.75 backup Log backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), first LSN: 77:8119:1, last LSN: 77:8119:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK18'}). 2010-07-08 01:00:08.05 backup Log backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), first LSN: 412437:18:1, last LSN: 412461:77:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK18'}). 2010-07-08 01:00:08.10 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK18] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK18] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-08 01:00:08.21 backup BACKUP failed to complete the command BACKUP LOG [MERCATI2] TO [SBS-BCK18] WITH INIT , NOUNLOAD , NAME = N'MERCATI2 backup', NOSKIP , STATS = 10, NOFORMAT BACKUP LOG [MERCATI] TO [SBS-BCK18] WITH NOINIT , NOUNLOAD , NAME = N'MERCATI backup', NOSKIP , STATS = 10, NOFORMAT BACKU 2010-07-08 02:00:04.38 backup Database log truncated: Database: MERCATI2. 2010-07-08 02:17:52.37 backup Database backed up: Database: MERCATI2, creation date(time): 2010/07/01(11:11:48), pages dumped: 3586447, first LSN: 42263:747272:1, last LSN: 42263:761689:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'CLU-BCK00'}). 2010-07-08 03:10:11.30 backup Database log truncated: Database: MERCATI. 2010-07-08 03:13:15.72 backup Database backed up: Database: MERCATI, creation date(time): 2010/02/15(12:47:16), pages dumped: 931532, first LSN: 24137:28871:1, last LSN: 24137:29094:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'SBS-BCK00'}). 2010-07-08 03:13:15.91 backup Database log truncated: Database: NETWEB. 2010-07-08 03:13:17.29 backup Database backed up: Database: NETWEB, creation date(time): 2010/02/23(00:56:28), pages dumped: 7219, first LSN: 77:8119:1, last LSN: 77:8122:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'SBS-BCK00'}). 2010-07-08 03:13:17.43 backup Database log truncated: Database: VARDATABSE. 2010-07-08 03:13:42.10 backup Database backed up: Database: VARDATABSE, creation date(time): 2010/02/23(01:14:12), pages dumped: 111147, first LSN: 412461:510:1, last LSN: 412462:25:1, number of dump devices: 1, device information: (FILE=3, TYPE=DISK: {'SBS-BCK00'}). 2010-07-08 03:13:42.19 backup Database log truncated: Database: ADBUSER. 2010-07-08 03:13:43.38 backup Database backed up: Database: ADBUSER, creation date(time): 2010/02/23(01:18:48), pages dumped: 743, first LSN: 114:119:1, last LSN: 114:121:1, number of dump devices: 1, device information: (FILE=4, TYPE=DISK: {'SBS-BCK00'}). 2010-07-08 03:14:49.94 backup Database backed up: Database: MSDB, creation date(time): 2000/08/06(01:40:56), pages dumped: 329749, first LSN: 17349986:764:1, last LSN: 17349986:772:1, number of dump devices: 1, device information: (FILE=5, TYPE=DISK: {'SBS-BCK00'}). 2010-07-08 03:14:50.02 backup Database log truncated: Database: VARDB. 2010-07-08 03:16:45.51 backup Database backed up: Database: VARDB, creation date(time): 2010/02/23(01:35:53), pages dumped: 126355, first LSN: 18540:10865:1, last LSN: 18540:10873:1, number of dump devices: 1, device information: (FILE=6, TYPE=DISK: {'SBS-BCK00'}). 2010-07-08 05:31:15.60 spid69 ex_raise2: Exception raised, major=79, minor=87, severity=22, attempting to create symptom dump 2010-07-08 05:31:15.68 spid69 Using 'dbghelp.dll' version '4.0.5' *Dump thread - spid = 69, PSS = 0x2db2d210, EC = 0x2db2d540 * * User initiated stack dump. This is not a server exception dump. * *Stack Dump being sent to e:\program files\microsoft sql server\mssql\data\MSSQL\log\SQLDump0984.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 07/08/10 05:31:15 spid 69 * * ex_raise2: Exception raised, major=79, minor=87, severity=22 * * Input Buffer 40 bytes - * exec sp_value_line 4 * * * MODULE BASE END SIZE * sqlservr 00400000 00CBAFFF 008bb000 * ntdll 77F80000 77FFBFFF 0007c000 * ADVAPI32 7C2D0000 7C334FFF 00065000 * KERNEL32 7C570000 7C623FFF 000b4000 * RPCRT4 77D30000 77D9EFFF 0006f000 * MSVCP71 7C3A0000 7C41AFFF 0007b000 * MSVCR71 7C340000 7C395FFF 00056000 * opends60 41060000 41065FFF 00006000 * SHELL32 7CF30000 7D175FFF 00246000 * GDI32 77F40000 77F7CFFF 0003d000 * USER32 77E10000 77E6EFFF 0005f000 * SHLWAPI 70A70000 70AD5FFF 00066000 * msvcrt 78000000 78044FFF 00045000 * COMCTL32 71710000 71793FFF 00084000 * sqlsort 42AE0000 42B6FFFF 00090000 * ums 41070000 4107DFFF 0000e000 * sqlevn70 41080000 4108AFFF 0000b000 * NETAPI32 02BF0000 02C3FFFF 00050000 * Secur32 02C40000 02C4DFFF 0000e000 * NTDSAPI 02C50000 02C60FFF 00011000 * DNSAPI 02C70000 02C94FFF 00025000 * WSOCK32 02CA0000 02CA7FFF 00008000 * WS2_32 02CB0000 02CC3FFF 00014000 * WS2HELP 02CD0000 02CD7FFF 00008000 * WLDAP32 02CE0000 02D0AFFF 0002b000 * NETRAP 02D10000 02D15FFF 00006000 * SAMLIB 02D20000 02D2FFFF 00010000 * AUTHZ 02D80000 02D8FFFF 00010000 * ole32 03020000 0310EFFF 000ef000 * XOLEHLP 03110000 03117FFF 00008000 * MSDTCPRX 03120000 031DAFFF 000bb000 * MTXCLU 031E0000 031EFFFF 00010000 * VERSION 031F0000 031F6FFF 00007000 * LZ32 03200000 03205FFF 00006000 * CLUSAPI 03210000 0321FFFF 00010000 * RESUTILS 03220000 0322CFFF 0000d000 * USERENV 03230000 03293FFF 00064000 * rnr20 032A0000 032ABFFF 0000c000 * iphlpapi 032F0000 03302FFF 00013000 * ICMP 03310000 03314FFF 00005000 * MPRAPI 03320000 03336FFF 00017000 * OLEAUT32 03340000 033DBFFF 0009c000 * ACTIVEDS 033E0000 0340EFFF 0002f000 * ADSLDPC 03410000 03432FFF 00023000 * RTUTILS 03440000 0344DFFF 0000e000 * SETUPAPI 03450000 034DDFFF 0008e000 * RASAPI32 034E0000 03513FFF 00034000 * rasman 03520000 03530FFF 00011000 * TAPI32 03540000 03561FFF 00022000 * DHCPCSVC 03570000 03588FFF 00019000 * winrnr 039B0000 039B7FFF 00008000 * rasadhlp 039C0000 039C4FFF 00005000 * SSNETLIB 040F0000 04105FFF 00016000 * NTMARTA 04150000 0416CFFF 0001d000 * WINSPOOL 04170000 0418DFFF 0001e000 * MPR 04190000 041A0FFF 00011000 * security 044B0000 044B3FFF 00004000 * msafd 04B50000 04B6CFFF 0001d000 * wshtcpip 04BE0000 04BE6FFF 00007000 * SSmsLPCn 04CD0000 04CD7FFF 00008000 * SSnmPN70 04CE0000 04CE6FFF 00007000 * mswsock 04D80000 04D91FFF 00012000 * kerberos 04DF0000 04E24FFF 00035000 * cryptdll 04E30000 04E3DFFF 0000e000 * MSASN1 04E40000 04E50FFF 00011000 * rsabase 051E0000 05202FFF 00023000 * CRYPT32 05210000 0529BFFF 0008c000 * SQLFTQRY 05420000 05445FFF 00026000 * CLBCATQ 05450000 054DEFFF 0008f000 * sqloledb 055E0000 0565CFFF 0007d000 * MSDART 05660000 05683FFF 00024000 * comdlg32 05690000 056CDFFF 0003e000 * MSDATL3 056D0000 056E4FFF 00015000 * oledb32 05A70000 05ADFFFF 00070000 * OLEDB32R 05AE0000 05AF0FFF 00011000 * msv1_0 05B90000 05BB1FFF 00022000 * xpsqlbot 05BC0000 05BC5FFF 00006000 * xplog70 05D00000 05D0EFFF 0000f000 * xplog70 05D10000 05D14FFF 00005000 * xpstar 05D50000 05D9CFFF 0004d000 * SQLRESLD 05DA0000 05DABFFF 0000c000 * SQLSVC 05DB0000 05DCAFFF 0001b000 * ODBC32 05DD0000 05E09FFF 0003a000 * odbcbcp 05E10000 05E15FFF 00006000 * W95SCM 05E20000 05E2CFFF 0000d000 * SQLUNIRL 10000000 1002FFFF 00030000 * SHFOLDER 05E30000 05E37FFF 00008000 * odbcint 05F80000 05F96FFF 00017000 * NDDEAPI 05FA0000 05FA6FFF 00007000 * SQLSVC 05FB0000 05FB5FFF 00006000 * xpstar 05FC0000 05FC8FFF 00009000 * impprov 05FE0000 05FF8FFF 00019000 * DBNETLIB 06970000 06989FFF 0001a000 * DBmsLPCn 06990000 06997FFF 00008000 * SQLOLEDB 06BA0000 06BAEFFF 0000f000 * msjetoledb40 072C0000 07313FFF 00054000 * msjet40 07320000 0748FFFF 00170000 * mswstr10 07490000 07524FFF 00095000 * msjter40 07530000 0753CFFF 0000d000 * MSJINT40 07540000 07565FFF 00026000 * COMSVCS 081A0000 0830FFFF 00170000 * TxfAux 08310000 08373FFF 00064000 * sqlmap70 0E350000 0E37CFFF 0002d000 * MAPI32 0E380000 0E3A0FFF 00021000 * adsldp 0E490000 0E4B2FFF 00023000 * adsmsext 0E4E0000 0E4F1FFF 00012000 * dbghelp 047C0000 048BFFFF 00100000 * * Edi: 2DB2D540: 2DB2D210 251D1490 251D1E08 2DB895D0 2DB895D0 2DB88038 * Esi: 2DB2D210: 00000045 00000000 005AA5B3 00009DAD 00000000 00000000 * Eax: 00000000: * Ebx: 0685D5B0: 000F9D40 00610072 00730069 00320065 0020003A 00780045 * Ecx: 0685D610: 00000000 0001003F 00000000 00000000 00000000 00000000 * Edx: 000FCF90: 00000000 2DB2D210 2DB2D540 00000001 00030002 00080100 * Eip: 009BA08C: 26EB0088 90909090 EC458B90 83E47D8B B3B904C7 8B000000 * Ebp: 0685D594: 0685DDD4 009BA9B5 2DB2D210 0685E260 0000004F 00000057 * SegCs: 0000001B: * EFlags: 00010246: 00720067 006D0061 00460020 006C0069 00730065 004D005C * Esp: 0685D56C: 2DB2D540 2DB2D210 0685D5B0 0685D610 0685D56C 0685D1B8 * SegSs: 00000023: * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump * 009BA08C Module(sqlservr+005BA08C) (GetOSErrString+00004F68) * 009BA9B5 Module(sqlservr+005BA9B5) (GetOSErrString+00005891) * 006EE757 Module(sqlservr+002EE757) (SQLExit+00186C60) * 005FA686 Module(sqlservr+001FA686) (SQLExit+00092B8F) * 0061F3A4 Module(sqlservr+0021F3A4) (SQLExit+000B78AD) * 00441ADA Module(sqlservr+00041ADA) * 004079CC Module(sqlservr+000079CC) * 0041D812 Module(sqlservr+0001D812) * 00401136 Module(sqlservr+00001136) * 4107295D Module(ums+0000295D) (UmsScheduler::IdleLoop+0000007D Line 1322+0000000D) * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000) * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000) * 00401261 Module(sqlservr+00001261) * 00408B31 Module(sqlservr+00008B31) * 004024E7 Module(sqlservr+000024E7) * 004022F9 Module(sqlservr+000022F9) * 00403578 Module(sqlservr+00003578) * 0040365A Module(sqlservr+0000365A) * 004080EC Module(sqlservr+000080EC) * 00406180 Module(sqlservr+00006180) * 0042A380 Module(sqlservr+0002A380) * 0043638B Module(sqlservr+0003638B) * 00438B4A Module(sqlservr+00038B4A) * 0042C7EF Module(sqlservr+0002C7EF) * 0086767D Module(sqlservr+0046767D) (GetIMallocForMsxml+00072AFD) * 005B820A Module(sqlservr+001B820A) (SQLExit+00050713) * 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F) * 004194B9 Module(sqlservr+000194B9) * 004193E4 Module(sqlservr+000193E4) * 00429EAA Module(sqlservr+00029EAA) * 00415D04 Module(sqlservr+00015D04) * 00416214 Module(sqlservr+00016214) * 00415F28 Module(sqlservr+00015F28) * 0050BCEF Module(sqlservr+0010BCEF) * 0050BB13 Module(sqlservr+0010BB13) * 00415D04 Module(sqlservr+00015D04) * 00416214 Module(sqlservr+00016214) * 00415F28 Module(sqlservr+00015F28) * 0049C32E Module(sqlservr+0009C32E) * 0049C46A Module(sqlservr+0009C46A) * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000) * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007) * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA) * 7C57B3BC Module(KERNEL32+0000B3BC) (lstrcmpiW+000000B7) * ------------------------------------------------------------------------------- 2010-07-08 05:31:20.01 spid69 Stack Signature for the dump is 0xC96B85C0 2010-07-08 05:31:20.02 spid69 ex_raise2: Exception raised, major=79, minor=87, severity=22, attempting to create symptom dump 2010-07-08 05:31:20.02 spid69 Using 'dbghelp.dll' version '4.0.5' *Dump thread - spid = 69, PSS = 0x2db2d210, EC = 0x2db2d540 * * User initiated stack dump. This is not a server exception dump. * *Stack Dump being sent to e:\program files\microsoft sql server\mssql\data\MSSQL\log\SQLDump0985.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 07/08/10 05:31:20 spid 69 * * ex_raise2: Exception raised, major=79, minor=87, severity=22 * * Input Buffer 40 bytes - * exec sp_value_line 4 * * * MODULE BASE END SIZE * sqlservr 00400000 00CBAFFF 008bb000 * Invalid Address 77F80000 77FFBFFF 0007c000 * ADVAPI32 7C2D0000 7C334FFF 00065000 * KERNEL32 7C570000 7C623FFF 000b4000 * RPCRT4 77D30000 77D9EFFF 0006f000 * MSVCP71 7C3A0000 7C41AFFF 0007b000 * MSVCR71 7C340000 7C395FFF 00056000 * opends60 41060000 41065FFF 00006000 * SHELL32 7CF30000 7D175FFF 00246000 * GDI32 77F40000 77F7CFFF 0003d000 * USER32 77E10000 77E6EFFF 0005f000 * SHLWAPI 70A70000 70AD5FFF 00066000 * msvcrt 78000000 78044FFF 00045000 * COMCTL32 71710000 71793FFF 00084000 * sqlsort 42AE0000 42B6FFFF 00090000 * ums 41070000 4107DFFF 0000e000 * sqlevn70 41080000 4108AFFF 0000b000 * NETAPI32 02BF0000 02C3FFFF 00050000 * Secur32 02C40000 02C4DFFF 0000e000 * NTDSAPI 02C50000 02C60FFF 00011000 * DNSAPI 02C70000 02C94FFF 00025000 * WSOCK32 02CA0000 02CA7FFF 00008000 * WS2_32 02CB0000 02CC3FFF 00014000 * WS2HELP 02CD0000 02CD7FFF 00008000 * WLDAP32 02CE0000 02D0AFFF 0002b000 * NETRAP 02D10000 02D15FFF 00006000 * SAMLIB 02D20000 02D2FFFF 00010000 * AUTHZ 02D80000 02D8FFFF 00010000 * ole32 03020000 0310EFFF 000ef000 * XOLEHLP 03110000 03117FFF 00008000 * MSDTCPRX 03120000 031DAFFF 000bb000 * MTXCLU 031E0000 031EFFFF 00010000 * VERSION 031F0000 031F6FFF 00007000 * LZ32 03200000 03205FFF 00006000 * CLUSAPI 03210000 0321FFFF 00010000 * RESUTILS 03220000 0322CFFF 0000d000 * USERENV 03230000 03293FFF 00064000 * rnr20 032A0000 032ABFFF 0000c000 * iphlpapi 032F0000 03302FFF 00013000 * ICMP 03310000 03314FFF 00005000 * MPRAPI 03320000 03336FFF 00017000 * OLEAUT32 03340000 033DBFFF 0009c000 * ACTIVEDS 033E0000 0340EFFF 0002f000 * ADSLDPC 03410000 03432FFF 00023000 * RTUTILS 03440000 0344DFFF 0000e000 * SETUPAPI 03450000 034DDFFF 0008e000 * RASAPI32 034E0000 03513FFF 00034000 * rasman 03520000 03530FFF 00011000 * TAPI32 03540000 03561FFF 00022000 * DHCPCSVC 03570000 03588FFF 00019000 * winrnr 039B0000 039B7FFF 00008000 * rasadhlp 039C0000 039C4FFF 00005000 * SSNETLIB 040F0000 04105FFF 00016000 * NTMARTA 04150000 0416CFFF 0001d000 * WINSPOOL 04170000 0418DFFF 0001e000 * MPR 04190000 041A0FFF 00011000 * security 044B0000 044B3FFF 00004000 * msafd 04B50000 04B6CFFF 0001d000 * wshtcpip 04BE0000 04BE6FFF 00007000 * SSmsLPCn 04CD0000 04CD7FFF 00008000 * SSnmPN70 04CE0000 04CE6FFF 00007000 * mswsock 04D80000 04D91FFF 00012000 * kerberos 04DF0000 04E24FFF 00035000 * cryptdll 04E30000 04E3DFFF 0000e000 * MSASN1 04E40000 04E50FFF 00011000 * rsabase 051E0000 05202FFF 00023000 * CRYPT32 05210000 0529BFFF 0008c000 * SQLFTQRY 05420000 05445FFF 00026000 * CLBCATQ 05450000 054DEFFF 0008f000 * sqloledb 055E0000 0565CFFF 0007d000 * MSDART 05660000 05683FFF 00024000 * comdlg32 05690000 056CDFFF 0003e000 * MSDATL3 056D0000 056E4FFF 00015000 * oledb32 05A70000 05ADFFFF 00070000 * OLEDB32R 05AE0000 05AF0FFF 00011000 * msv1_0 05B90000 05BB1FFF 00022000 * xpsqlbot 05BC0000 05BC5FFF 00006000 * xplog70 05D00000 05D0EFFF 0000f000 * xplog70 05D10000 05D14FFF 00005000 * xpstar 05D50000 05D9CFFF 0004d000 * SQLRESLD 05DA0000 05DABFFF 0000c000 * SQLSVC 05DB0000 05DCAFFF 0001b000 * ODBC32 05DD0000 05E09FFF 0003a000 * odbcbcp 05E10000 05E15FFF 00006000 * W95SCM 05E20000 05E2CFFF 0000d000 * SQLUNIRL 10000000 1002FFFF 00030000 * SHFOLDER 05E30000 05E37FFF 00008000 * odbcint 05F80000 05F96FFF 00017000 * NDDEAPI 05FA0000 05FA6FFF 00007000 * SQLSVC 05FB0000 05FB5FFF 00006000 * xpstar 05FC0000 05FC8FFF 00009000 * impprov 05FE0000 05FF8FFF 00019000 * DBNETLIB 06970000 06989FFF 0001a000 * DBmsLPCn 06990000 06997FFF 00008000 * SQLOLEDB 06BA0000 06BAEFFF 0000f000 * msjetoledb40 072C0000 07313FFF 00054000 * msjet40 07320000 0748FFFF 00170000 * mswstr10 07490000 07524FFF 00095000 * msjter40 07530000 0753CFFF 0000d000 * MSJINT40 07540000 07565FFF 00026000 * COMSVCS 081A0000 0830FFFF 00170000 * TxfAux 08310000 08373FFF 00064000 * sqlmap70 0E350000 0E37CFFF 0002d000 * MAPI32 0E380000 0E3A0FFF 00021000 * adsldp 0E490000 0E4B2FFF 00023000 * adsmsext 0E4E0000 0E4F1FFF 00012000 * dbghelp 0CEC0000 0CFBFFFF 00100000 * * Edi: 2DB2D540: 2DB2D210 251D1490 2DB895D0 2DB2D54C 2DB2D54C 2DB88038 * Esi: 2DB2D210: 00000045 00000000 005AA5B3 00009DAD 00000000 00000000 * Eax: 00000000: * Ebx: 06858124: 000F9D40 00610072 00730069 00320065 0020003A 00780045 * Ecx: 06858184: 00000000 0001003F 00000000 00000000 00000000 00000000 * Edx: 000FCF90: 00000000 2DB2D210 2DB2D540 00000001 00030002 00080100 * Eip: 009BA08C: 26EB0088 90909090 EC458B90 83E47D8B B3B904C7 8B000000 * Ebp: 06858108: 06858948 009BA9B5 2DB2D210 06858DD4 0000004F 00000057 * SegCs: 0000001B: * EFlags: 00010246: 00720067 006D0061 00460020 006C0069 00730065 004D005C * Esp: 068580E0: 2DB2D540 2DB2D210 06858124 06858184 068580E0 06857D2C * SegSs: 00000023: * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump * 009BA08C Module(sqlservr+005BA08C) (GetOSErrString+00004F68) * 009BA9B5 Module(sqlservr+005BA9B5) (GetOSErrString+00005891) * 006EE757 Module(sqlservr+002EE757) (SQLExit+00186C60) * 005FA686 Module(sqlservr+001FA686) (SQLExit+00092B8F) * 0061F3A4 Module(sqlservr+0021F3A4) (SQLExit+000B78AD) * 00441ADA Module(sqlservr+00041ADA) * 004079CC Module(sqlservr+000079CC) * 0041D812 Module(sqlservr+0001D812) * 00401136 Module(sqlservr+00001136) * 41074AC0 Module(ums+00004AC0) (UmsThreadScheduler::Switch+00000020 Line 475+00000000) * 410729F9 Module(ums+000029F9) (UmsScheduler::IdleLoop+00000119 Line 1373+0000000D) * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000) * 004023C4 Module(sqlservr+000023C4) * 00402406 Module(sqlservr+00002406) * 00403616 Module(sqlservr+00003616) * 00405BCD Module(sqlservr+00005BCD) * 00405E94 Module(sqlservr+00005E94) * 00405F07 Module(sqlservr+00005F07) * 0040612D Module(sqlservr+0000612D) * 00406180 Module(sqlservr+00006180) * 00448E05 Module(sqlservr+00048E05) * 005E8E6D Module(sqlservr+001E8E6D) (SQLExit+00081376) * 005E933D Module(sqlservr+001E933D) (SQLExit+00081846) * 005F97F0 Module(sqlservr+001F97F0) (SQLExit+00091CF9) * 005F8CB8 Module(sqlservr+001F8CB8) (SQLExit+000911C1) * 005FA686 Module(sqlservr+001FA686) (SQLExit+00092B8F) * 0061F3A4 Module(sqlservr+0021F3A4) (SQLExit+000B78AD) * 00441ADA Module(sqlservr+00041ADA) * 004079CC Module(sqlservr+000079CC) * 0041D812 Module(sqlservr+0001D812) * 00401136 Module(sqlservr+00001136) * 4107295D Module(ums+0000295D) (UmsScheduler::IdleLoop+0000007D Line 1322+0000000D) * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000) * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000) * 00401261 Module(sqlservr+00001261) * 00408B31 Module(sqlservr+00008B31) * 004024E7 Module(sqlservr+000024E7) * 004022F9 Module(sqlservr+000022F9) * 00403578 Module(sqlservr+00003578) * 0040365A Module(sqlservr+0000365A) * 004080EC Module(sqlservr+000080EC) * 00406180 Module(sqlservr+00006180) * 0042A380 Module(sqlservr+0002A380) * 0043638B Module(sqlservr+0003638B) * 00438B4A Module(sqlservr+00038B4A) * 0042C7EF Module(sqlservr+0002C7EF) * 0086767D Module(sqlservr+0046767D) (GetIMallocForMsxml+00072AFD) * 005B820A Module(sqlservr+001B820A) (SQLExit+00050713) * 005B8266 Module(sqlservr+001B8266) (SQLExit+0005076F) * 004194B9 Module(sqlservr+000194B9) * 004193E4 Module(sqlservr+000193E4) * 00429EAA Module(sqlservr+00029EAA) * 00415D04 Module(sqlservr+00015D04) * 00416214 Module(sqlservr+00016214) * 00415F28 Module(sqlservr+00015F28) * 0050BCEF Module(sqlservr+0010BCEF) * 0050BB13 Module(sqlservr+0010BB13) * 00415D04 Module(sqlservr+00015D04) * 00416214 Module(sqlservr+00016214) * 00415F28 Module(sqlservr+00015F28) * 0049C32E Module(sqlservr+0009C32E) * 0049C46A Module(sqlservr+0009C46A) * 41075309 Module(ums+00005309) (ProcessWorkRequests+000002D9 Line 456+00000000) * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007) * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA) * 7C57B3BC Module(KERNEL32+0000B3BC) (lstrcmpiW+000000B7) * ------------------------------------------------------------------------------- 2010-07-08 05:31:21.18 spid69 Stack Signature for the dump is 0x56B574D8 2010-07-08 05:31:21.19 spid69 Error: 7987, Severity: 22, State: 1. 2010-07-08 05:31:21.19 server Using 'dbghelp.dll' version '4.0.5' *Stack Dump being sent to e:\program files\microsoft sql server\mssql\data\MSSQL\log\SQLDump0986.txt 2010-07-08 05:31:21.21 server SqlDumpExceptionHandler: Process 1520 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. * ******************************************************************************* * * BEGIN STACK DUMP: * 07/08/10 05:31:21 spid 0 * * Exception Address = 410729C8 (UmsScheduler::IdleLoop + 000000E8 Line 1365+0000001A) * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION * Access Violation occurred writing address 00000004 * * MODULE BASE END SIZE * sqlservr 00400000 00CBAFFF 008bb000 * ntdll 77F80000 77FFBFFF 0007c000 * ADVAPI32 7C2D0000 7C334FFF 00065000 * KERNEL32 7C570000 7C623FFF 000b4000 * RPCRT4 77D30000 77D9EFFF 0006f000 * MSVCP71 7C3A0000 7C41AFFF 0007b000 * MSVCR71 7C340000 7C395FFF 00056000 * opends60 41060000 41065FFF 00006000 * SHELL32 7CF30000 7D175FFF 00246000 * GDI32 77F40000 77F7CFFF 0003d000 * USER32 77E10000 77E6EFFF 0005f000 * SHLWAPI 70A70000 70AD5FFF 00066000 * msvcrt 78000000 78044FFF 00045000 * COMCTL32 71710000 71793FFF 00084000 * sqlsort 42AE0000 42B6FFFF 00090000 * ums 41070000 4107DFFF 0000e000 * sqlevn70 41080000 4108AFFF 0000b000 * NETAPI32 02BF0000 02C3FFFF 00050000 * Secur32 02C40000 02C4DFFF 0000e000 * NTDSAPI 02C50000 02C60FFF 00011000 * DNSAPI 02C70000 02C94FFF 00025000 * WSOCK32 02CA0000 02CA7FFF 00008000 * WS2_32 02CB0000 02CC3FFF 00014000 * WS2HELP 02CD0000 02CD7FFF 00008000 * WLDAP32 02CE0000 02D0AFFF 0002b000 * NETRAP 02D10000 02D15FFF 00006000 * SAMLIB 02D20000 02D2FFFF 00010000 * AUTHZ 02D80000 02D8FFFF 00010000 * ole32 03020000 0310EFFF 000ef000 * XOLEHLP 03110000 03117FFF 00008000 * MSDTCPRX 03120000 031DAFFF 000bb000 * MTXCLU 031E0000 031EFFFF 00010000 * VERSION 031F0000 031F6FFF 00007000 * LZ32 03200000 03205FFF 00006000 * CLUSAPI 03210000 0321FFFF 00010000 * RESUTILS 03220000 0322CFFF 0000d000 * USERENV 03230000 03293FFF 00064000 * rnr20 032A0000 032ABFFF 0000c000 * iphlpapi 032F0000 03302FFF 00013000 * ICMP 03310000 03314FFF 00005000 * MPRAPI 03320000 03336FFF 00017000 * OLEAUT32 03340000 033DBFFF 0009c000 * ACTIVEDS 033E0000 0340EFFF 0002f000 * ADSLDPC 03410000 03432FFF 00023000 * RTUTILS 03440000 0344DFFF 0000e000 * SETUPAPI 03450000 034DDFFF 0008e000 * RASAPI32 034E0000 03513FFF 00034000 * rasman 03520000 03530FFF 00011000 * TAPI32 03540000 03561FFF 00022000 * DHCPCSVC 03570000 03588FFF 00019000 * winrnr 039B0000 039B7FFF 00008000 * rasadhlp 039C0000 039C4FFF 00005000 * SSNETLIB 040F0000 04105FFF 00016000 * NTMARTA 04150000 0416CFFF 0001d000 * WINSPOOL 04170000 0418DFFF 0001e000 * MPR 04190000 041A0FFF 00011000 * security 044B0000 044B3FFF 00004000 * msafd 04B50000 04B6CFFF 0001d000 * wshtcpip 04BE0000 04BE6FFF 00007000 * SSmsLPCn 04CD0000 04CD7FFF 00008000 * SSnmPN70 04CE0000 04CE6FFF 00007000 * mswsock 04D80000 04D91FFF 00012000 * kerberos 04DF0000 04E24FFF 00035000 * cryptdll 04E30000 04E3DFFF 0000e000 * MSASN1 04E40000 04E50FFF 00011000 * rsabase 051E0000 05202FFF 00023000 * CRYPT32 05210000 0529BFFF 0008c000 * SQLFTQRY 05420000 05445FFF 00026000 * CLBCATQ 05450000 054DEFFF 0008f000 * sqloledb 055E0000 0565CFFF 0007d000 * MSDART 05660000 05683FFF 00024000 * comdlg32 05690000 056CDFFF 0003e000 * MSDATL3 056D0000 056E4FFF 00015000 * oledb32 05A70000 05ADFFFF 00070000 * OLEDB32R 05AE0000 05AF0FFF 00011000 * msv1_0 05B90000 05BB1FFF 00022000 * xpsqlbot 05BC0000 05BC5FFF 00006000 * xplog70 05D00000 05D0EFFF 0000f000 * xplog70 05D10000 05D14FFF 00005000 * xpstar 05D50000 05D9CFFF 0004d000 * SQLRESLD 05DA0000 05DABFFF 0000c000 * SQLSVC 05DB0000 05DCAFFF 0001b000 * ODBC32 05DD0000 05E09FFF 0003a000 * odbcbcp 05E10000 05E15FFF 00006000 * W95SCM 05E20000 05E2CFFF 0000d000 * SQLUNIRL 10000000 1002FFFF 00030000 * SHFOLDER 05E30000 05E37FFF 00008000 * odbcint 05F80000 05F96FFF 00017000 * NDDEAPI 05FA0000 05FA6FFF 00007000 * SQLSVC 05FB0000 05FB5FFF 00006000 * xpstar 05FC0000 05FC8FFF 00009000 * impprov 05FE0000 05FF8FFF 00019000 * DBNETLIB 06970000 06989FFF 0001a000 * DBmsLPCn 06990000 06997FFF 00008000 * SQLOLEDB 06BA0000 06BAEFFF 0000f000 * msjetoledb40 072C0000 07313FFF 00054000 * msjet40 07320000 0748FFFF 00170000 * mswstr10 07490000 07524FFF 00095000 * msjter40 07530000 0753CFFF 0000d000 * MSJINT40 07540000 07565FFF 00026000 * COMSVCS 081A0000 0830FFFF 00170000 * TxfAux 08310000 08373FFF 00064000 * sqlmap70 0E350000 0E37CFFF 0002d000 * MAPI32 0E380000 0E3A0FFF 00021000 * adsldp 0E490000 0E4B2FFF 00023000 * adsmsext 0E4E0000 0E4F1FFF 00012000 * dbghelp 047C0000 048BFFFF 00100000 * * Edi: 0027F248: 41076154 00000000 00000000 0027CE54 00276F64 0416152E * Esi: 00276EF8: 41076770 00000001 00000013 00000000 00ECB790 00000004 * Eax: 065D22E0: 41076154 00000000 00000000 0027F54C 00278C3C 040CD794 * Ebx: 00276F80: 01164A8D 002412BE 00000001 00000000 00140009 000C0100 * Ecx: 00000000: * Edx: 00000000: * Eip: 410729C8: 89044A89 89C93311 48890848 604EFF04 10244489 000045C6 * Ebp: 00276F50: 00000001 00000001 00000003 00000000 00276F98 0027F254 * SegCs: 0000001B: * EFlags: 00010213: 4E004900 54004E00 53005C00 73007900 65007400 33006D00 * Esp: 0685FEBC: 0027F248 00276EF8 000DBBA0 000DBBA0 00000000 41072B26 * SegSs: 00000023: * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump * 410729C8 Module(ums+000029C8) (UmsScheduler::IdleLoop+000000E8 Line 1365+0000001A) * 41072B26 Module(ums+00002B26) (UmsScheduler::Suspend+00000066 Line 1182+00000000) * 4107311B Module(ums+0000311B) (UmsEvent::Wait+0000007B Line 320+00000000) * 410751BD Module(ums+000051BD) (ProcessWorkRequests+0000018D Line 365+00000000) * 41074978 Module(ums+00004978) (ThreadStartRoutine+00000098 Line 263+00000007) * 7C34940F Module(MSVCR71+0000940F) (endthread+000000AA) * 7C57B3BC Module(KERNEL32+0000B3BC) (lstrcmpiW+000000B7) * ------------------------------------------------------------------------------- *Dump thread - spid = 1, PSS = 0x42c3c0c0, EC = 0x42c3c3f0 *Stack Dump being sent to e:\program files\microsoft sql server\mssql\data\MSSQL\log\SQLDump0986.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 07/08/10 05:31:21 spid 1 * * StackDump (all) * * * * Edi: 000002E4: * Esi: 77F88F08: 0000EAB8 24548D00 C22ECD04 FF8B000C 0000EBB8 24548D00 * Eax: 00000230: * Ebx: 00000000: * Ecx: 0000B5F2: * Edx: 00000000: * Eip: 77F88F13: 8B000CC2 00EBB8FF 548D0000 2ECD0424 8B0004C2 00ECB8FF * Ebp: 03D6FB14: 00276D48 41074AEE 000002E4 FFFFFFFF 00000001 002773E0 * SegCs: 0000001B: * EFlags: 00000246: * Esp: 03D6FAF0: 7C59A0A2 000002E4 00000001 00000000 7C59A031 002773E0 * SegSs: 00000023: * ******************************************************************************* * ------------------------------------------------------------------------------- * Short Stack Dump * 77F88F13 Module(ntdll+00008F13) (NtWaitForSingleObject+0000000B)
From: Erland Sommarskog on 8 Jul 2010 16:57 Alberto (assistenza(a)adb.it) writes: > as you can read below, there is a sql server error log of last failure. That looks bad. You would have to contact Microsoft support to get an analysis of this dump. But I would suspect that the ultimate reason for the problem is hardware related. Or at least related to a bad driver. > in previous system we had -T9059 into startup, and now we have tried with > and without but no differences seems to be relevant. I find it difficult to believe that the trace flag is related to the errorm, given what it does: http://support.microsoft.com/kb/899976. > Windows 2000 AS starts with /PAE because we have 6 GB memory, but SQL runs > just 2048 MB (without awe) beause we just don't need; so should we enable > awe ? Sinec SQL Server will not allocate more memory than it needs, it would do no harm to enable AWE. I don't think it is relevant for these crashes, though. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
Pages: 1 Prev: ODBC microsoft text driver(*.txt; *.csv) for vista 64 Next: How to tie table to schema? |