Post reply

database

  • April 11, 2003 at 7:17 am

    #58620

    hello,

    the msdb on sqlserver7 has been suspect.

    how do you think is the best option to troubleshoot the problem?

    thanks,

  • April 11, 2003 at 7:21 am

    #453874

    hi,

    a good starting point is DBCC CHECKDB <db_name> Also take a look at DBCC in BOL.

    Good luck

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 11, 2003 at 7:27 am

    #453877

    Check your SQL Server errorlog and machine application/system logs first to try to figure out why the database is suspected.

    Read BOL "Resetting the Suspect Status" and sp_resetstatus for more information.

  • April 11, 2003 at 7:57 am

    #453886

    THANK YOU ALL

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

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