MEVCUT MDF VE LDF SI OLAN DATAYI SQL2005 TE ATTACH EDILMEYE CALISILDIGINDA ASAGIDAKI HATA ILE KARSILASIYORUM.

 

EOleException: SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:13356; actual 0:0). It occurred during a read of page (1:13356) in database ID 9 at offset 0x00000006858000 in file 'C:\Documents and Settings\Administrator\Desktop\ENTEGREW3\TOYGUN08.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.

 

COZUM OLARAK YAPILANLAR

 

DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS
GO
EXEC sp_resetstatus 'TOYGUN08';
GO
ALTER DATABASE TOYGUN08 SET EMERGENCY
GO
DBCC CHECKDB('TOYGUN08')
GO
ALTER DATABASE TOYGUN08 SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DBCC CHECKDB ('TOYGUN08', REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE TOYGUN08 SET MULTI_USER
GO
ALTER DATABASE TOYGUN08 SET ONLINE

2 . CUZUM

NET TEN BULABILDIGIM HER SEY KISACASI AMA MALESEF BIRTURLU DUZELTEMEDIM.

 

YARDIMLARINIZ ICIN SIMDEN TSK.LER.