August 6, 2008 at 5:13 am
Hi Friends,
I m getting below error while installing SCCM 2007.
" ***SqlError: [HY000][824][Microsoft][ODBC SQL Server Driver][SQL Server]SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:12771; actual 0:0). It occurred during a read of page (1:12771) in database ID 7 at offset 0x000000063c6000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SMS_123.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe 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.
Failed to execute sql command ALTER TABLE dbo.[LU_SoftwareHash] ADD CONSTRAINT [LU_SoftwareHash_PK] PRIMARY KEY CLUSTERED (SoftwarePropertiesHash) WITH FILLFACTOR = 80
FAILED Sql Script: Could not create primary key on table LU_SoftwareHash
Setup cannot create the required database tables. Contact your SQL administrator."
Can any one help me in this? As i do not have much knowledge of SQL.
Thanks in advance.
August 6, 2008 at 8:41 am
I'm not sure what "SCCM 2007" is, but the error message is saying that there's a serious problem with your database and you'll probably have to recover it from a backup.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 6, 2008 at 8:51 am
Thanks for your reply. 🙂
Is there any command or any other way using which I can make it perfect?
I tried to install SLQ 2 times, but getting same error.
Appreciate you if provide me solution for this.
FYI............
SCCM is a tool which uses SQL database to store its information. It is a software which we can use to do lots of thing remotely in Domain.
August 6, 2008 at 9:52 am
Start by running DBCC CHECKDB on the database.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 7, 2008 at 10:53 am
what does the SQLSvr Error Log have posted for this timeframe?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply