question

roelof.k avatar image
roelof.k asked

how to fix SQL database?help

Hi everyone. I have a question….How to fix sql database when generating an errors 823? Please help me to out this! Thanks
sqldatabaseerror
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

kosciKi avatar image
kosciKi answered
Sql error 823 occurs when a read of a page fails at the OS layer hence throws error to the user. The main reason of this exception error is associated with overloaded storage, hard disk going bad, faulty drivers, incorrectly configured disk subsystem, etc. This problem can be solved with the help of external trustful software. For example SQL Server Fix Toolbox [ http://www.sqlserver.fixtoolbox.com/][1] I found it here [ http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/725-%E2%80%8Bsql-server-fix][2] [1]: http://www.sqlserver.fixtoolbox.com/ [2]: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/725-%E2%80%8Bsql-server-fix
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@SQLShark avatar image
@SQLShark answered
Have you had a look at MSDN? https://msdn.microsoft.com/en-us/library/aa337267.aspx A Windows read or write request has failed. The error code that is returned by Windows and the corresponding text are inserted into the message. In the read case, SQL Server will have already retried the read request four times. This error is often the result of a hardware error, but may be caused by the device driver. For more information about error 823, see http://support.microsoft.com/kb/828339. For more information about I/O errors, see Microsoft SQL Server I/O Basics, Chapter 2.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

raadee avatar image
raadee answered
Do not go downloading "trustful" software before troubleshooting the error by yourself. Go to this link [ http://support.microsoft.com/kb/2015755][1] to start troubleshooting the problem first. [1]: http://support.microsoft.com/kb/2015755
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.