SQL Server Performance

DBCC CHECKDB, MSSQLSERVER_8974 error in tempdb

Discussion in 'SQL Server 2005 General DBA Questions' started by jn4u, Dec 5, 2007.

  1. jn4u Member

    <p><span><font face="Arial" size="2"><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font size="3"><font face="Calibri">During the night I run a checkdb that reported a error in tempdb, log down in post for more info.</font></font></span></p><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font face="Courier">Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 0, text ID 296853831680 is not referenced.</font></span></p><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font size="3"><font face="Calibri">If run a checkdb know it’s not finding any problem. I’m bit confused what to do restart the server to get new tempdb? </font></font></span><span lang="EN-US"><font size="3"><font face="Calibri">I check with for SQL Server 2005 Books Online for the “MSSQLSERVER_8974” error, it tells me to look after a “Look for Hardware Failure”.&nbsp; </font></font></span><span lang="EN-US"><font size="3"><font face="Calibri">In the sql server log its stands that its have found 82 errors </font></font></span></p><p class="MsoNormal" style="margin: 0cm 0cm 10pt;" align="left"><span lang="EN-US"><font size="-0"><font face="Calibri">DBCC CHECKDB (tempdb) executed by AIR5MSSQLService found 82 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 3 seconds.</font></font></span></p><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font size="3"><font face="Calibri">Directly after this a stackdump are generated. Somewhere in the middle of my dbcc script.</font></font></span></p><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font size="3"><font face="Calibri">After the i get the result of the next databases.</font></font></span></p><p class="MsoNormal" style="margin: 0cm 0cm 10pt;"><span lang="EN-US"><font face="Calibri">DBCC CHECKDB (model) executed by AIR5MSSQLService found 0 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.</font></span></p><p align="left"><u>This is compress version of the log of dbcc job</u></p><p align="left"><font face="Courier">NEW COMPONENT OUTPUT<br>Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3042<br>Report was generated on "FLEFSE".<br>Maintenance Plan: Underhåll<br>Duration: 00:12:55<br>Status: Warning: One or more tasks failed..<br>Details:<br>Check Database Integrity (FLEFSE)<br>Execute TSQL on Local server connection<br>Execution time out: 1800<br>Task start: 2007-12-05T02:00:01.<br>Task end: 2007-12-05T02:12:57.<br>Failed<img src="http://forums.microsoft.com/MSDN/emoticons/emotion-6.gif" alt="Sad">-1073548784) Executing the query "DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR<br>SELECT name FROM sys.databases WHERE state_desc='ONLINE'<br>OPEN AllDatabases</font></p><p align="left"><font face="Courier">DECLARE @DBNameVar NVARCHAR(128)<br>DECLARE @Statement NVARCHAR(300)</font></p><p align="left"><font face="Courier">FETCH NEXT FROM AllDatabases INTO @DBNameVar<br>WHILE (@@FETCH_STATUS = 0)<br>BEGIN<br>&nbsp;&nbsp; PRINT N'CHECKING DATABASE ' + @DBNameVar<br>&nbsp;&nbsp; SET @Statement = N'USE ' + @DBNameVar + CHAR(13)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + N'DBCC CHECKDB (' + @DBNameVar + N')' <br>&nbsp;&nbsp; EXEC sp_executesql @Statement<br>&nbsp;&nbsp; PRINT CHAR(13) + CHAR(13)<br>&nbsp;&nbsp; FETCH NEXT FROM AllDatabases INTO @DBNameVar<br>END</font></p><p align="left"><font face="Courier">CLOSE AllDatabases<br>DEALLOCATE AllDatabases<br>" failed with the following error: "Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 0, text ID 296853831680 is not referenced.<br>Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 1, text ID 296853897216 is not referenced.<br>&nbsp;... to ...<br>Table error: Object ID 1109769969, index ID 0, partition ID 72057595983888384, alloc unit ID 72057596039200768 (type LOB data). The off-row data node at page (6:459), slot 81, text ID 296871985152 is not referenced.<br>CHECKING DATABASE master<br>DBCC results for 'master'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'master'.<br>DBCC results for 'mssqlsystemresource'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'mssqlsystemresource'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE tempdb<br>DBCC results for 'tempdb'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 82 consistency errors in table '#4225BEF1' (object ID 1109769969).<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 82 consistency errors in database 'tempdb'.<br>repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (tempdb).<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE model<br>DBCC results for 'model'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'model'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE msdb<br>DBCC results for 'msdb'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'msdb'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE ReportServer<br>DBCC results for 'ReportServer'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'ReportServer'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE ReportServerTempDB<br>DBCC results for 'ReportServerTempDB'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'ReportServerTempDB'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE caisqlp<br>DBCC results for 'caisqlp'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'caisqlp'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE BKALKYL<br>DBCC results for 'BKALKYL'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'BKALKYL'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE distribution<br>DBCC results for 'distribution'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'distribution'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE DMVstatsDB<br>DBCC results for 'DMVstatsDB'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'DMVstatsDB'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE BALDATA<br>DBCC results for 'BALDATA'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'BALDATA'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE VirtualCenterDB<br>DBCC results for 'VirtualCenterDB'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'VirtualCenterDB'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE BINGE01<br>DBCC results for 'BINGE01'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'BINGE01'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE BMATINK<br>DBCC results for 'BMATINK'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'BMATINK'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE BORDE01<br>DBCC results for 'BORDE01'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'BORDE01'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE BSTATISTIK<br>DBCC results for 'BSTATISTIK'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'BSTATISTIK'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE MPSmartDB<br>DBCC results for 'MPSmartDB'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'MPSmartDB'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE SmarTeamPilot<br>DBCC results for 'SmarTeamPilot'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'SmarTeamPilot'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE STATISTIK<br>DBCC results for 'STATISTIK'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'STATISTIK'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE VBAS<br>DBCC results for 'VBAS'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'VBAS'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE MDataMM_0F<br>DBCC results for 'MDataMM_0F'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'MDataMM_0F'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE DLDB<br>DBCC results for 'DLDB'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'DLDB'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><font face="Courier">CHECKING DATABASE ILDB<br>DBCC results for 'ILDB'.<br>.... removed lines ...<br>CHECKDB found 0 allocation errors and 0 consistency errors in database 'ILDB'.<br>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</font></p><p align="left"><br><font face="Courier">". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.</font></p><p align="left"><font face="Courier">Command:USE master;<br>GO<br>SET NOCOUNT ON;<br>GO<br>DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR<br>SELECT name FROM sys.databases WHERE state_desc=''ONLINE''<br>OPEN AllDatabases</font></p><p align="left"><font face="Courier">DECLARE @DBNameVar NVARCHAR(128)<br>DECLARE @Statement NVARCHAR(300)</font></p><p align="left"><font face="Courier">FETCH NEXT FROM AllDatabases INTO @DBNameVar<br>WHILE (@@FETCH_STATUS = 0)<br>BEGIN<br>&nbsp;&nbsp; PRINT N''CHECKING DATABASE '' + @DBNameVar<br>&nbsp;&nbsp; SET @Statement = N''USE '' + @DBNameVar + CHAR(13)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + N''DBCC CHECKDB ('' + @DBNameVar + N'')'' <br>&nbsp;&nbsp; EXEC sp_executesql @Statement<br>&nbsp;&nbsp; PRINT CHAR(13) + CHAR(13)<br>&nbsp;&nbsp; FETCH NEXT FROM AllDatabases INTO @DBNameVar<br>END</font></p><p align="left"><font face="Courier">CLOSE AllDatabases<br>DEALLOCATE AllDatabases<br>GO<br>SET NOCOUNT OFF;<br>GO</font></p><p align="left">&nbsp;</p><p align="left"><u>This is the top of the stack-dump</u></p><p align="left"><font face="Courier">=====================================================================&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BugCheck Dump&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>=====================================================================&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>This file is generated by Microsoft SQL Server&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>version 9.00.3042.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>upon detection of fatal unexpected error. Please return this file,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>the query or program that produced the bugcheck, the database and&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>the error log, and any other pertinent information with a Service Request.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Computer type is AT/AT COMPATIBLE.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Current time is 02:00:08 12/05/07.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>8 Unknown CPU 9., 2333 Mhz processor (s).&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Windows NT 5.2 Build 3790 CSD Service Pack 2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Memory&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>MemoryLoad = 98%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Total Physical = 8189 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Available Physical = 163 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Total Page File = 9795 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Available Page File = 1527 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Total Virtual = 8388607 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>Available Virtual = 8373732 MB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></p><p align="left"><br><font face="Courier">DBCC RESULTS<br>--------------------</font></p><p align="left">&nbsp;</p><p align="left"><font face="Courier">&nbsp;... lines removed ....</font></p><p align="left"><font face="Courier">**Dump thread - spid = 107, PSS = 0x00000000EE497BC0, EC = 0x00000000EE497BD0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>***Stack Dump being sent to C:program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0009.txt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* *******************************************************************************&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* BEGIN STACK DUMP:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp; 12/05/07 02:00:08 spid 107&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* DBCC database corruption&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* Input Buffer 510 bytes -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp; SELECT name FROM sys.databases WHERE state_desc='ONLINE'&nbsp; OPEN AllDatab&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; ases&nbsp;&nbsp;&nbsp; DECLARE @DBNameVar NVARCHAR(128)&nbsp; DECLARE @Statement NVARCHAR(30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; 0)&nbsp;&nbsp;&nbsp; FETCH NEXT FROM AllDatabases INTO @DBNameVar&nbsp; WHILE (@@FETCH_STATU&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; S = 0)&nbsp; BEGIN&nbsp;&nbsp;&nbsp;&nbsp; PRINT N'CHECKING DATABASE ' + @DBNameVar&nbsp;&nbsp;&nbsp;&nbsp; SET @Stat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; ement = N'USE ' + @DBNameVar + CHAR(13)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + N'DBCC CHECKDB (' + @DB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; NameVar + N')'&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXEC sp_executesql @Statement&nbsp;&nbsp;&nbsp;&nbsp; PRINT CHAR(13) + C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; HAR(13)&nbsp;&nbsp;&nbsp;&nbsp; FETCH NEXT FROM AllDatabases INTO @DBNameVar&nbsp; END&nbsp;&nbsp;&nbsp; CLOSE A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp; llDatabases&nbsp; DEALLOCATE AllDatabases&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* *******************************************************************************&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* -------------------------------------------------------------------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br>* Short Stack Dump&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></p><p align="left"><font face="Courier">PSS @0x00000000EE497BC0<br>-----------------------<br></font></p><p align="left"><font size="3"><u>My DBCC script looks like this</u></font></p><p align="left"><font face="Courier">USE master;<br>GO<br>SET NOCOUNT ON;<br>GO<br>DECLARE AllDatabases CURSOR LOCAL FAST_FORWARD READ_ONLY FOR<br>SELECT name FROM sys.databases WHERE state_desc='ONLINE'<br>OPEN AllDatabases</font></p><p align="left"><font face="Courier">DECLARE @DBNameVar NVARCHAR(128)<br>DECLARE @Statement NVARCHAR(300)</font></p><p align="left"><font face="Courier">FETCH NEXT FROM AllDatabases INTO @DBNameVar<br>WHILE (@@FETCH_STATUS = 0)<br>BEGIN<br>&nbsp;&nbsp; PRINT N'CHECKING DATABASE ' + @DBNameVar<br>&nbsp;&nbsp; SET @Statement = N'USE ' + @DBNameVar + CHAR(13)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; + N'DBCC CHECKDB (' + @DBNameVar + N')' <br>&nbsp;&nbsp; EXEC sp_executesql @Statement<br>&nbsp;&nbsp; PRINT CHAR(13) + CHAR(13)<br>&nbsp;&nbsp; FETCH NEXT FROM AllDatabases INTO @DBNameVar<br>END</font></p><p align="left"><font face="Courier">CLOSE AllDatabases<br>DEALLOCATE AllDatabases<br>GO<br>SET NOCOUNT OFF;<br>GO</font></p></font></span>&nbsp;</p>
  2. techbabu303 New Member

    Has anything changes recently like the ones listed below ?
    • Before and after any SQL Server service pack or hotfix installations.
      • Before and after any major database application upgrades.
        • Before and after any Windows operating system service pack or hotfix installations or upgrade.
          • Before and after any hardware or system maintenance such as drivers, firmware updates, new hardware installation, or replacement of hardware components.
          Personally I would not repair the temdb instead restart services to get a new tempdb is this viable option run checkdb before a complete backup.
          Cheers
          Sat
  3. harini.hanu New Member

    hi iam getting this error while executing integrity checks Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'Address', NOINDEX)
    " failed with the following error: "Database 0 cannot be autostarted during server shutdown or startup.
    The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
    DBCC results for 'Address'
    please anyone reply asap
    any reply please
  4. arunyadav Member

    I encountered the same issue what I did is: close management studio and restart SQL server. You can try the same...
  5. harini.hanu New Member

    thanks for the reply
  6. harini.hanu New Member

    hi iam getting the error while creating the maintanance plan in sql server 2005. the error is
    TITLE: Microsoft SQL Server Management Studio Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (msddsp)
    please anyone know wat the error is please reply asap.please explain wat this erro is.
  7. SqlMan4u New Member

  8. harini.hanu New Member

    Server: Msg 3441, Level 17, State 1, Line 1
    Database 'AscentCapture' (database ID 5). The RESTORE statement could not access file '\3idbb001y$MSSQL$DCDBAscentCaptureAscentCapture_LOGAscentCapture_200904141130.tuf'. Error was '2(The system cannot find the file specified.)'.
    Server: Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.
    please reply asap


  9. arunyadav Member

    Check the following:

    1. The backup file and the instance you are restoring the file on to are of same or, lower to higher version.
    2. The latest Service Pack is installed.
    3. The path is correct.
    4. The account used to start SQL server service has access rights to the folder specified.
  10. harini.hanu New Member

    hi frnds iam getting the following error can some one explain wat is this error how i resolve it please help asap .
    error:HP SIM2 REPORTING MINOR ALARM - CORRECTED MEMORY ERROR THRESHOLD EXCEEDED (SYSTEM MEMORY, MEMORY MODULE 3)
    frnds any help very urgent. thanks in advance
  11. satya Moderator

    It seems to be alert generated from a third party monitoring tool, is it so?
  12. harini.hanu New Member

    hi all ,
    i am getting the error xml returned from engine was invalid. i got this error while taking transaction log backup.i found the solution in google1)Add the @maxtransfersize parameter to the backup and reducing the size to 500Kb (512000), then perform the backup again.

    2)The other parameter that has been used in conjunction with the MaxTransferSize parameter has been the Threads parameter. By default this is set to 3. Add the parameter @threads to the backup script and reduce it to 1. The best results have been found using 2-3 on a multi-processor environment. This parameter is available within the LiteSpeed Backup options from the Enterprise Console.

    3) SQL Server's MemToLeave area becoming fragmented so that there is insufficient contiguous space to allocate the buffers required for the backups. Microsoft's suggestion to resolving the issue is to use the start-up parameter '-g' with SQL Server. The '-g' parameter can be set in Enterprise Manager by right-clicking on the server, selecting 'Properties' and clicking on the Start-Up parameters button at the bottom of the properties window. The default -g setting is 128Mb. It is recommended that -g256 is used, if this does not resolve the issue increase the value to -g512. Changing these settings does require SQL Server to be restarted for the changes to take affect and in production environments this is not always possible.

    4) NT Fibers work best when the server has multiple CPUs and a relatively low user to CPU ratio. For example, on an Enterprise installation with 32 CPUs and 250 users, you may see a noticeable performance boost with fibers. But when you have eight CPUs and 5000 users, you may see performance decrease with fibers. LightWeight Pooling is an advanced option. Sp_configure system stored procedure allows verification as well as a change to system settings in SQL Server 2000 and 2005. Note, for a change to this setting to take effect requires a restart SQL Server services

    To figure out the contiguous transfer size set up currently run the command XP_MEMORY_SIZE from within Query Analyzer. This should change if the -g setting is implemented.
    this is the solution which i found .can someone throw more light on this topic
  13. dhamu294 New Member

    great it is useful

Share This Page