Forum Replies Created

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

  • RE: SQL Agent Process in Runnable even after KILLING

    Can't say I have a complete answer here, but we experience similar occurences. The cause in each case is with SQL mail and its inability to recover from a...

  • RE: BACKING UP MULTIPLE DATABASE

    Not sure if your saying that you MUST use Netbackup? If you don't need to use Netbackup then why not use the already available SQL Server Maintenance plans. This...

  • RE: error log

    Or via Enterprise Manager

    expand instance

    expand Management

    expand sql server logs

    Logs presented are the currentlog and as many archives as you have set to keep

  • RE: Recovery model from simple to full

    As per Nigels comments re profiling it should throw some light on the problem. If you say you 'manualy' backed them up and they remained at full then when run...

  • RE: Recovery model from simple to full

    The answer to you question is as follows:

    The recovery model on msdb reverts to “simple” every time the SQLServerAgent service starts (SQLServer-imposed feature)

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