error 823:i/o error (bad page id) detected during reading... c:\...mssql\data\master.mdf

  • hi ,

     

    I have a problem with creating new database users. when I click "new database users"  , this errro messages

    occurs. Is there anyone who fixed these before?

     

    thanks for your help

  • if you look in books online under "error 823" it explains what is wrong. check the servers system logs for any hard disk or io subsystem errors. if there isnt anything then checkdb will tell you what is wrong.  If you are using external storage you can lose data if there has been power outage/brown out and it is not on a ups (search online for battery cache if this is the case). i would guess the error occurs in master db which is why it only occurs when you create new users. try running checkdb on this first and then run it on all databases to make sure.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply