Post reply

Database turning to Suspect

  • May 18, 2005 at 9:52 pm

    #86393

    Hi Gurus,

    Am in a media company that takes live data from various data providers. we have several writes to the database, last day the server stopped responding & when we rebooted it then our main database was showing the suspect flag. tried to detach & attach the database but it was displaying some I/O error when attaching a MDF file ....

    Is there any way to recover it from suspect status or we can only rely on the latest backup ..

    please help...

    Thanks and Regards,

    Hemant

  • May 18, 2005 at 11:52 pm

    #559776

    did you try

    Execute sp_resetstatus?

    if not check the BOL for more details.

    Resetting the Suspect Status

    Microsoft® SQL Server™ 2000 returns error 1105 and sets the status column of sysdatabases to suspect if SQL Server is unable to complete recovery on a database because the disk drive no longer has any free space. Follow these steps to resolve the problem:

    1. Execute sp_resetstatus.
    2. Use ALTER DATABASE to add a data file or log file to the database.
    3. Stop and restart SQL Server.

      With the extra space provided by the new data file or log file, SQL Server should be able to complete recovery of the database.

    4. Free disk space and rerun recovery.

  • May 19, 2005 at 2:33 am

    #559785

    First of all you need to determine the cause of suspect status. What are messages in SQL Server error log on server startup or during detach/attach? Are there any messages in Windows logs?

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

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