Post reply

Demo: Full msdb log error#9002 and Demo: Full tempdb

  • March 22, 2009 at 8:05 pm

    #71994

    I check my alerts and get this error:Demo: Full msdb log, and Demo: Full tempdb what is this mean and what should I do??

  • March 23, 2009 at 12:23 pm

    #964665

    There are a few "demo" alerts that come with SQL server 2000, these being two of them. Mine are enabled so they will fire if a threshold has been reached, where either the tempdb or msdb log become full. My databases are set for autogrow and the inital size of my tempdb log is big enough so that neither of these conditions have ever been reached. If you're getting the actual alert, take a look at the log files and increase them where necessary. Even if your database is set to simple recovery mode, the log file can still fill up, depending on what job is running.

    -- You can't be late until you show up.

  • April 8, 2010 at 10:52 pm

    #1148812

    Iam also facing the same issue in one of our production sql server

    Any other sugessions please

    Enabled Error Security Lastoccured

    Demo : Full msdb log yes 9002 0 Never

    Demo : Full tempdb yes 9002 0 Never

    Thanks in advance

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

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