January 21, 2014 at 8:19 am
I got the following error running a scheduled Update statistics job on one of user databases. Can anyone have me on this issue? Thanks
The operating system returned error stale page (a page read returned a log sequence number (LSN) (219608:3136:1) that is older than the last one that was written (0:0:0)) to SQL Server during a read at offset 0x0000000b3f0000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
January 21, 2014 at 8:31 am
I'd suggest following the recommendations in the error message and run DBCC CHECKDB. Depending on where the statistics are, and if there are any other underlying problems, you may be able to get away with just dropping the statistic or the index associated with it (if it's not a column statistic). But you need to start with the consistency check.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 21, 2014 at 8:35 am
As Grant suggested I would run this:DBCC CHECKDB WITH ALL_ERRORMSGS, NO_INFOMSGS;
If you get anything back (other than "Command(s) completed successfully") post the entire message to this post.
January 22, 2014 at 9:41 am
Run DBCC CHECKDB on the user database? I just wonder why the error message refers to the tempdb.mdf file.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply