.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Stack Dump generated on the db and SQL tipped over DBCC CHECKDB came out clean

Posted By:      Posted Date: August 31, 2010    Points: 0   Category :Sql Server
 
We have Profile db for sharepoint 2010 and the SQL tipped over just before which it generated the below dump. The DBCC CHECKDB on the database came out clean. The SQL Server is SQL 2008 SP1 CU5 and the memory on the server is 32GB with max. for SQL Server being 26 GB.  What could have caused this? There is nothing in the error log prior to this dump. name                                minimum     maximum     config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- access check cache bucket count     0           65536       0            0 access check cache quota            0           2147483647  0            0 Ad Hoc Distributed Queries          0           1           0


View Complete Post


More Related Resource Links

Should DR testing include DBCC CheckDB

  
We have EMC storage and use SRDFa to replicate production data to another location.  In the coming weeks we'll be doing some DR testing that will involve interrupting replication, then mounting the 'DR' storage on our staging servers.  I'll attach the databases and testing will begin.  I'm wondering if standard practice should include running DBCC CheckDB against the 'recovered' databases before turning them over to the users. [We're running SQL 2005 SP2 Enterprise (64-bit) on a 6 node Active-Passive cluster.  The OS is Win 2003.]

DBCC CHECKDB('DB Name', REPAIR_REBUILD).

  
    Do I have to run the DBCC CHECKDB('DB Name', REPAIR_REBUILD) in single user mode, have no users using the DB?  Not sure. If I have no users using the DB, can I still run without putting the server in single user mode?      Thanks for help   

Database temporary corruption - DBCC CHECKDB error

  
I've run into a very strange and frustrating recurring error. I have a Single instance SQL Server 2005 DBMS on Win2K3 Server x86.  The problem occurs with a *single* database on the system, the other databases are unaffected.  We primarily access this database for editing through an Access 2007 data project, though it's accessed (select only) from many places using odbc or oledb. Basically some sort of corruption (or apparent corruption) occurs after a server update and reboot (usually unrelated to the DB software).  After that, the database is fine sometimes, other times it is fine until we try to access it via the ADP.  At that point it becomes inaccesssible by the ADP, though it can still be accessed through all other methods.  Running DBCC CHECKDB (databasename) returns: Msg 211, Level 23, State 51, Line 1 Possible schema corruption. Run DBCC CHECKCATALOG. Running DBCC CHECKCATALOG (databasename) returns no errors. Restarting the database service (from inside SSMS typically) will fix it *eventually* after a few restarts.  I can find no rhyme or reason to the apparent corruption.  I'll be glad to look and post any other log entries that might be relevant.  I should note that the database was originally created way back in SQL Server 7, though it's got no real customizations, triggers, and very few constraints on it.  It's

DBCC CHECKDB Blocking Itself SQL 2008 MSCRM

  
Hello I've got a nightly job that runs DBCC CHECKDB WITH TABLERESULTS for all databases, using sp_msforeachdb, and then saves the results into a table, tidies them up, and then disappears off. On my test MSCRM database, the DBCC CHECKDB command is blocking itself. The only way to resolve this self-blocking seems to be to restart SQL. sp_who2 won't execute, but sp_who does. DBCC INPUTBUFFER tells me that it's the stored procedure I'm executing causing the blocking.  A bit more searching into sys.dm_os_waiting_tasks and and sys.dm_exec_connections suggests that this piece of code is causing the problem: DECLARE @BlobEater VARBINARY(8000)   SELECT @BlobEater = CheckIndex (ROWSET_COLUMN_FACT_BLOB)  FROM { IRowset 0xE093909D00000000 }  GROUP BY ROWSET_COLUMN_FACT_KEY  >> WITH ORDER BY    ROWSET_COLUMN_FACT_KEY,    ROWSET_COLUMN_SLOT_ID,    ROWSET_COLUMN_COMBINED_ID,    ROWSET_COLUMN_FACT_BLOB  OPTION (ORDER GROUP)  with a wait_type of LCK_M_IX the resource type is objectlock lockPartition=0 objid=34 subresource=FULL dbid=2 id=lock8defbd80 mode=SIX associatedObjectId=34 Trying to rollback the transaction doesn't help: it just sits in a rollback sort of a state. Trying to stop SQL doesn't work too well: going into Task Manager on the Server and killing the sqlserver.exe pr

Does DBCC CHECKDB without additional arguments perform repairs if there is a consistency problem?

  
Does DBCC CHECKDB without additional arguments perform repairs if there is a consistency problem?

For example DBCC CHECKDB REPAIR_REBUILD?
Mr Shaw

remove stack trace , Additional Info, from log file

  

i am using belowcode in web.config 

<loggingConfiguration name="" tracingEnabled="true" defaultCategory="General">
    <listeners>
      <add name="Rolling Flat File Trace Listener" type="Microsoft.Practices.EnterpriseLibrary.Logging.TraceListeners.RollingFlatFileTraceListener, Microsoft.Practices.EnterpriseLibrary.Logging, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.RollingFlatFileTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=5.0.414.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" fileName=".\Logs\jeejix_error.log" footer="------------Error End----------------------------" formatter="Text Formatter" header="---------Error Start-------------------------------" rollFileExistsBehavior="Increment" rollInterval="Day" rollSizeKB="50" />
    </listeners>
    <formatters>
      <add type="Microsoft.Practices.EnterpriseLibrary.Logging.Formatters.TextFormatter, Microsoft.Practices.EnterpriseLibrary.Logging, Version=5.0.414.0, Culture=neutral, PublicKeyToken

DBCC CHECKDB

  

does  DBCC CHECKDB  actually repair the SQL Database??

if so, could someone give me code on using the command?

 

 

 I am using the Express version of SQL Server, 2008.

 

 


Running Dbcc CheckDB on Production Server databases.

  

Hi Guys 

I am new to SQL Server Administration. I have set up the Backup jobs according to the requirements from the Application team. Also I have set tip the  update stats, Reindexing Job every 2 weeks as far as the maintenance as maintenance is concerned. I am using  SQL Scripts in the SQL Agent to perform all these jobs

But i have not scheduled any Integrity Check (CheckDB ) Jobs on any of the database in any of the servers. I have databases of Size 1Gb-50 GB and few from 100-600 Gb. 

I want to set up the integrity jobs on all the databases. Can you please suggest me some best ways how I can schedule jobs every 2 or 3 weeks on small databases and on big databases like 100 - 600 GB in SQL Server 2005,2008. 

 

Thanks 

 


Calling Procedure from ADO.NET with a Name That Starts with Sys Causes SQL Server Stack Dump

  

After the better part of 5 hours, I finally figured out why I was getting this SqlException:  {"A severe error occurred on the current command.  The results, if any, should be discarded.\r\nA severe error occurred on the current command.  The results, if any, should be discarded."}

If you call a stored procedure that *starts* with Sys (e.g. dbo.SystemConfigurationUpdate, dbo.SystolicPatientRecords, or SyscoFoodsPurchase) and at least one specified variable is a Table Value Parameter, SQL Server 2008 stack dumps (below).

If you add anything to the front of the Sys, it works fine (e.g. mSysConfigUpdate or mSys).

 

--- STACK DUMP ---

***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0037.txt

SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

* *******************************************************************************

*

* BEGIN STACK DUMP:

*   11/02/10 10:25:14 spid 54

*

*

*   Exception Address = 000000000105A8B0 Module(sqlservr+00000000002DA8B0)

*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

*   Access Violation occu

Downside of Regular DBCC SHRINKFILE (compact) and DBCC CHECKDB (repair)

  

Having come from the MS Access world, many people wonder if there is a similar tool in SQL Server or SQL Server Express that mimics the Access Compact & Repair.

Although it is possible, I've read that it is not best policy to regularly compact and repair SQL Server databases using DBCC SHRINKFILE (compact) and DBCC CHECKDB (repair).

Can anyone tell me why running these commands would be a bad thing?  What would be a better plan of attack especially for small companies with minimal staff and maybe not even a resident DBA (i.e. typical users of SQL Server Express).

Thanks.


I ran dbcc checkdb on one testdatabase ,getting following errors, how to fix it?

  

Hi Friends,

could you please provide the solution for below error,

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8646911284551352320 (type Unknown), page (289:0). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 62916873 and -1.

Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8646673261154795520 (type Unknown), page ID (3:240120) contains an incorrect page ID in its page header. The PageId in the page header = (0:34871552).

Repairing this error requires other errors to be corrected first.

Msg 8909, Level 16, State 1, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8596527261321199616 (type Unknown), page ID (3:313995) contains an incorrect page ID in its page header. The PageId in the page header = (16249:36607).

Repairing this error requires other errors to be corrected first.

Msg 8939, Level 16, State 98, Line 1

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8430570274608381952 (type Unknown), page (42240:-1694459136). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29362441 and -1.

Repairing

DBCC CHECKDB against master DR Test on a different instance

  

As part of of the DR testing for the company I work for, we have to take a database backup file and restore it to a different instance on a different server and then run DBCC CHECKDB.  In this particular case one of the databases that needed to be tested was a master database (2008 not R2).  I recovered the 2008 database to our DR server (which already has a named 2008 instance up and running) and the restore completed successfully, however when I ran DBCC CHECKDB ('XXXXXX_master') I received the following output:

DBCC results for 'XXXXX_master'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3851, State 1: An invalid row (class=12,depid=0,depsubid=0) was found in the system table sys.syssingleobjrefs (class=12).
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3851,

dbcc checkdb script for many DB checking & printing out the results?

  

Hi All;

I would like to set a job for a health checking. I want to run the command DBCC CHECKDB for a number of databases. So how the script will gonna be? Is the below one is correct:

USE DB1

DBCC CHECKDB

GO

USE DB2

DBCC CHECKDB

GO

USE DB 3

DBCC CHECKDB

GO

will this run the first DB then will go to the second one? What If there is any error in the first dbcc checking? How would I know? Is there is a possiblity to send the results to Excel/.txt file for each database?


Database corrupt not able to recover by DBCC Checkdb

  

Weekly integrity check jobs for one of our critical database are failing with the following Error. We fixed the error by DBCC CHECKDB ALLOW DATALOSS. But again the integrity job is failing for other tables. When we check the object_name of objectid it wont be there in sysobjects or database. We checked the disks using chkdsk, no bad sectors found. 

Database is on SQl Server 2000 instance, having Service pack 4 applied.  Please suggest.

[1] Database XXX: Check Data and Index Linkage...        
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 2576: [Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (3:51165) object ID 1275867612 index ID 0 but was not detected in the scan.            
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (1:424) object ID 1275867612 index ID 9 but was not detected in the scan.                                                                     
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous pointer of IAM page (1:481) object ID 1275867612 index ID 10 but was not detected in the scan.                                                                    
[Microsoft][ODBC SQL Server Driver][SQL Server]IAM page (0:0) is pointed to by the previous poin

Decoding 3DES encoded viewstate in stack dump

  

In my Application_Error handler in global.aspx, I email myself some information if my web app faults on my remote server. Included in the information I email myself is my viewstate. I would really like to decode the viewstate so I can get a better picture of what is going on at the time of the fault.

The problem is that my viewstate is 3DES encoded. In my web.config I have a <machineKey> tag, with a fixed validationKey, descryptionKey, and validation="3DES". So in theory I can base-64 decode my viewstate and decrypt it with my validationKey (?). I'm having a problem finding the right tools to do this. I've found some viewstate decoders but they either fail (presumably because it's 3DES encrypted?) or spit out some data that I don't know how to 3DES decrypt.

What is the encoding/encrypting sequence here, does the server first encrypt then base-64 encode? So to reverse I need a base-64 decoder that won't choke and then some kind of 3DES decryption tool for the result, does anyone have any suggestions? Or is there some sourcode code I can use to cobble together a little decrypter of my one?


Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any

  

Hello!

I'm using Asp.NET 4 to perform a simple query on database.
But when navigating to page that needs data (i'm using SqlDataSource) i receive this internal error.
I already ran DBCC without error and i still have the issue.

Windows 2003 Standard with latest updates 32-bit
Sql Server Standard 2005 SP4

The same query, executed from SSMS works fine.


Il saggio è quello che sa di non sapere

Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0026.txt

  
Hello all,

I found on one of our server restart automatically after show stack dum error.
some part of log is given below any help will be appreciate.


Memory                              
MemoryLoad = 46%                    
Total Physical = 4094 MB            
Available Physical = 2172 MB        
Total Page File = 5971 MB           
Available Page File = 4226 MB       
Total Virtual = 2047 MB             
Available Virtual = 306 MB          
**Dump thread - spid = 51, PSS = 0x3D859580, EC = 0x3D859588                                                    
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0026.txt             
* *******************************************************************************                               
*                                                                                                               
* BEGIN STACK DUMP:                                                                                             
*   07/21/09 11:05:01 spid 51                                                                                   
*                                                                                                               
* e
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend