Post reply

Suspect databases

  • February 27, 2002 at 3:01 am

    #57757

    One of my DB is suspect... CHECKDB found 0 allocation errors and 0 consistency errors in the database. I restart the SQL server and it's fine. But that occurs... every 2 weeks !!!! What can I do to repair that DB ???

  • February 27, 2002 at 5:10 am

    #424561

    Have you checked in the SQLServer Log to see what error may be occurring when this happens or if anything specific is logged. Also check event viewer. Finally are you using sp_resetstatus before stopping and start server. If not read up on this.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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