Log in | Register

Corruption Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Corruption Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Corruption

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server sqlDumper application

Hi Friends,

May be in your DBA carrier you never used SQL Server sqldumper application but for a DBA, you should have the working knowledge of this application. Our focus in this blog is to explain the below things:

1-      What is sqlDumper.exe?
2-      Why we use it?
3-      How can we use it?

What is sqlDumper.exe?

SqlDumper.exe is an […]

sql server trace flag 3023

Hi Friends,

This is my 10th blog on SQL Server Trace Flag 3023 in the series of One Trace Flag a Day. You can go to all blogs under that series by clicking here.

Backup database is a very important operation for a DBA. There are so many options available while you are taking backup like […]

SQL Server Transactions – How to deal with Deferred Transactions?

Dear Friends,

Few weeks back, I blogged on SQL Server Transactions Deferred Transactions which I thought is not complete if I do not write on how we deal with them in general?

To recap, when recovery fails for a user database and the reason for the recovery is a damaged database page, instead the database is marked as […]

SQL Server REPAIR ALLOW DATA LOSS – Quick look

Dear Friends,

At different times when DBCC CHECKDB reports any consistency issues, selectively we run CHECKDB with SQL Server REPAIR ALLOW DATA LOSS to fix them. Today we will discuss in short what this really means and some consistency issues we can address using this option.

This repair option in essence means that CHECKDB detected at least […]

SQL Server Error 5242, 5243 (RecBase)

Hi Friends,

SQL Server 2005 users very frequently confronted with various types of assertion failures and one of such error is SQL Server Error 5242, shown as following;

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database ‘YourCorruptDatabase'(ID:10) on page (1:35293). Please contact technical support. Reference number 4.

SQL […]

SQL Server error 825, Read Retry

Dear Friends,

There are different scenarios where read operation fails in first attempt and when retried gets successful may be in second, third or even fourth attempt. SQL Server development team adopted this strategy and any read failure 823 or 824 will be tried four times before SQL Engine reports a failure.

As per MDSN, SQL […]

Could not read and latch page with latch type SH. sysindexes failed

Dear Friends,

SQL Server 2000 has already reached end of support state but many of us still see them on our environments. As long as we do not migrate these instances to a supported/higher edition, we need to support them as database admins. This is not an exception in my case also i.e. most of […]

SQL Server – SQL Server has detected an unreported OS/hardware level read or write problem on page (1:74098) of database 10

Dear Friends,

Sometime back while auditing error logs in one of the SQL Server instances I came across following message;

SQL Server has detected an unreported OS/hardware level read or write problem on page (1:74098) of database 10

LSN returned (59991:12571:175), LSN expected (59991:12571:600)

Contact the hardware vendor and consider disabling caching mechanisms to correct the problem

As can […]

Newsletter_Footer