I am getting some SQL related error while installing SCCM 2007.
The error message is as below-
<08-06-2008 16:12:41> ***SqlError: [HY000][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.
<08-06-2008 16:12:41> Failed to execute sql command ALTER TABLE dbo.[LU_SoftwareHash] ADD CONSTRAINT [LU_SoftwareHash_PK] PRIMARY KEY CLUSTERED (SoftwarePropertiesHash) WITH FILLFACTOR = 80
<08-06-2008 16:12:41> FAILED Sql Script: Could not create primary key on table LU_SoftwareHash
<08-06-2008 16:12:41> SQL error <>
<08-06-2008 16:12:42> Setup cannot create the required database tables. Contact your SQL administrator.
As I do not have expertise of SQL, please tell me how to resolve this issue.
Thanks in advance.
[REQ} SQL error
1 reply to this topic
Posted 06 November 2009 - 04:44 PM
Whenever you face SQL errors and warnings, first of all, run the DBCC CHECK command to know the reason and resolution of the error being occurred. After knowing, repair the SQL database with the suggested repair clause.. But if still you are getting error, then consider any efficient recovery software.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users