October 18, 2011 at 10:55 am
I got the error for tempdb while executing a script.Pls advise.
Msg 824, Level 24, State 2, Line 74
SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x85505bd1). It occurred during a read of page (1:1224) in database ID 2 at offset 0x00000000990000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\tempdb.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.
pls help on this
October 24, 2011 at 9:37 am
tempdb will be recreated anytime you restart SQL Server, however you may have issues with your I/O subsystem, a common source of DB corruption. Have you run DBCC CHECKDB on the model database? How about all your user databases?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
October 25, 2011 at 7:26 am
I have the same error with other databases also
FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf'. Diagnose and correct the operating system error, and retry the operation.
FCB::RemoveAlternateStreamsByHandle(BackupSeek): Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\model.mdf'. Diagnose and correct the operating system error, and retry the operation.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply