none
MSDB suspected problem in SQL2000 RRS feed

  • 問題

  •  

    We found that our SQL2000 Server MSDB marked suspected.

    Do you have any solution to solve this problem?

    2009年1月23日 上午 09:14

所有回覆

  • Any disk related error in windows system event log? Does disk have enough free space?

    • 已提議為解答 rmiao 2009年1月29日 下午 02:20
    2009年1月23日 下午 01:51
  • Please check the error log and tell us what you found,

    http://msdn.microsoft.com/en-us/library/aa937559(SQL.80).aspx
    The Microsoft® SQL Server™ 2000 error log can be viewed using SQL Server Enterprise Manager or any text editor. The most current error log is named Errorlog (with no extension) and is located in the Program Files\Microsoft SQL Server\Mssql\Log directory by default.

     


    Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA
    2009年1月29日 上午 09:50
  • We found a error in SQL Server Log.
    Error: 1105, Serverity: 15, State: 2

    2009年2月2日 上午 08:53
  • I also found the following error in SQL Server Log.

    LogEvent: Failed to report the current event.
    Operating system error = 31(error not found).
    2009年2月2日 上午 08:58
  • Did you check windows event logs on the server? May have disk problem.
    2009年2月2日 下午 05:00
  • For the Error 1105, by default it means your disk is running low. You have to move the MSDB to other partition. However, usually error 1105 is coming with Serverity 17. Any other message in the Error 1105? Or you may try to move the MSDB to other partition or free up some spaces on the partition where MSDB is located.

    http://msdn.microsoft.com/en-us/library/aa258767(SQL.80).aspx
    Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA
    2009年2月3日 上午 03:12
  • The Server have about 1.8GB free space.
    2009年2月4日 上午 04:23
  • KL_Poon 表示:

    We found a error in SQL Server Log.
    Error: 1105, Serverity: 15, State: 2



    any detail message?
    Microsoft MVP, Microsoft Community Star(TW & HK), MCT, MCSD, MCAD, MCSE+I, MCDBA, MCDST, MCSA
    2009年2月4日 上午 08:44
  • KL_Poon 表示:

    The Server have about 1.8GB free space.

    Cleanup disk to get more free space.

    2009年2月16日 下午 07:16