Try using these to make sure you are seeing accurate data for the database.

DBCC UPDATEUSAGE (0)

That one will make sure that EM properties for the database are accurate.

DBCC SQLPERF (...

andyhpoole wrote:

The sql 2000 boxes don't have exhange server on them yet so there won't be an issue there (YET?).

Andy P

--------------------------------

I don't mean to second guess you or anything,...

I keep reading about these complex methods DBAs are designing for SQL Mail on multiple servers.

Here is what we do in order to keep it simple and keep the complexity...

Here is what works for me.

Get a mail account called domain\sqlmail (insert whatever you want).

Make sure that same account has an exchange account and/or any mail server your company uses.

Have...

I am not sure specifically about your issue, but I have a way that makes all the mail work regardless. We use it within our cluster.

We only have SQLMail installed...

billsalkin wrote:

Prior to the nightly backup job we stop SQL server (to grab the mdf/ldf files) and then restart SQL.

-------------------

I am not trying to criticize your process, but that...

I really see no reason to have MSDB in "FULL" mode. It is not a transaction heavy database. And what sort of transactions are even there? It records when jobs...