Thank you for your replies. I'll probably stick with SP4 and live with these error messages.

I experienced transient 605 errors in the past (with subsequent DBCC CHECKDB showing no errors) on one of my servers. What in the end resolved the issue was the update of controller...

When I want to schedule tracing I use profiler GUI to choose events, filters... and then script the trace, run the script to create server-side trace and setup SQL Server Agent Jobs...

SQLBill, I didn't mean databases generally but solely system databases. Of course, it's best practice to separate data files and log files. We all know the reasons quite well.

On the...

I'm not sure whether you can achieve this on install. You can customize location of binnaries and database files, but I don't know how to separate data files and log...

What solution are you using? Builtin log shipping under Maintenance Plans in Enterprise Edition or something else?

I tested log shipping based on the SQL Server 2000 Resource Kit example which I changed...

I would setup a server side trace and filter TextData column for occurrences of the procedures and periodically check the trace files. Not so elegant, not so proactive but much...

I'm glad that this procedure helped you get out of trouble. In fact it works even in the case you lost all secondary data files to extract data from primary...

In EM you can use either (local) or .

to register Local default instance. Are you using one of these?

I don't know if it's still relevant but here are the steps I performed several times in test env as a part of disaster recovery tests:

1.First, backup all database files...

To rename db you can use sp_renamedb proc or ALTER DATABASE statement. Renaming of physical files is not so straightforward:

1.detach db from the server (sp_detach_db proc)

2.rename the file(s)

3.attach db back...

this might help

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Personally, I would feel rather uneasy about it. I would reinstall OS, of course if it was possible.

What are you trying to do? If you want to be notified when the backup fails, you can use Notifications table in job definition to send email, net send message or page...

What error messages are in SQL Server Log? By default it gets installed here:

C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG

As your instance won't go up you probably can't use EM to view error...

You're welcome. Excellent source on index fragmentation and methods to deal with it is here.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx