Sorry, I should've mentioned that it is writing to the event log. However, it goes as a warning. ELM (I don't know enough about this tool, yet) seems to onlypickup...

I'll talk to the person who made the recovery mode change, that's human error. What I need is to somehow add the error of the maintenance plan failure. If I...

This doesn't sound good but you could have corruption in the database. Check out. Google can provide other hits as well. Good Luck.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=190516

or

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/449455#

Did you ever think of using a maintenance plan? This will run, depending on your selections, all backups in sequential order. I have one that backs up all user databases....

Sorry, when I reread what you wanted to do, 818 jumped out at me. Looks like you're good to go! Good luck with getting them to agree to SP4. Also,...

This might be what you're looking for:

http://support.microsoft.com/?scid=http%3a%2f%2fwww.support.microsoft.com%2fkb%2f821277%2f

Why are you simply applying hotfixes and not moving to SP4? Do you have a specific issue going on?

While I agree with almost everything Phil said regarding the size and importance of the sytem databases and backing up to separate files, nightly backups may not be totally necessary....

It is 8.00.760 I can also raise this error when I restore a database in the development environment. The servers are identical, dual CPU and hyperthreading. It does run to...

It's actually Backup Exec 9.1 which sits on top of SQL server. Reporting, for my needs, is limited so I'm trying to query the underlying tables to extract data that...

I'm returning the same number of rows, the same 1st three fields, but the 4th one comes through with a different value ('') as opposed to 1, 0 or ''.

Never mind. When they installed the software, the network guys followed the instructions and set authentication to Windows Only, not the usual mixed mode. Once I set it correctly within the...

To simply check row counts, you can run the following against version 7 and then 2000 and compare the results.

select o.name as "Table Name",i.rows as "Row Count"

from sysobjects o, sysindexes i

where...

Check out http://www.microsoft.com/sql/downloads/2000/sp4.mspx They posted a hotfix for the AWE problem.

Yeah, I have roughly 20 production servers running SQL. I've never used or saw MSDE until this morning. Thanks for the advice, I'll give it a shot.