Solved

SQL Server 2005 Database error

Posted on 2010-08-25
2
812 Views
Last Modified: 2012-05-10
We are getting this error when we run the CC on our database.  Is there anyway out of this:

Event Type: Error

Event Source: MSSQLSERVER

Event Category: (2)

Event ID: 8966

Date: 8/24/2010

Time: 7:52:27 PM

User: NPTH-PATRIOT-FS\patriot1

Computer: NPTH-PATRIOT-FS

Description:

Unable to read and latch page (1:461016) with latch type SH. UtilDbccVerifyPageId failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 06 23 00 00 10 00 00 00 .#......

0008: 10 00 00 00 4e 00 50 00 ....N.P.

0010: 54 00 48 00 2d 00 50 00 T.H.-.P.

0018: 41 00 54 00 52 00 49 00 A.T.R.I.

0020: 4f 00 54 00 2d 00 46 00 O.T.-.F.

0028: 53 00 00 00 07 00 00 00 S.......

0030: 6d 00 61 00 73 00 74 00 m.a.s.t.

0038: 65 00 72 00 00 00 e.r...
0
Comment
Question by:hmcnasty
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Expert Comment

by:krsreddy5
ID: 33524071
0
 

Accepted Solution

by:
hmcnasty earned 0 total points
ID: 33890862
We ended up backing up the database adn then restoring it to a new database.  This solved the problem
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question