Did you try using dts/ssis package to move jobs...

I believe there is a jobs transfer task in dts...

OR you may need to check SMO/DMO scripts to create the jobs...

There are many bugs in SP4... they have been fixed in cumulative patch...or atleast you have to apply hotfix related awe issue...

FIX: Not all memory is available when AWE is...

There are many bugs in SP4... they have been fixed in cumulative patch...or atleast you have to apply hotfix related awe issue...

FIX: Not all memory is available when AWE is...

Is your web servers access db2 in any way?

How is the connection string or odbc configured for your web servers to connect to db1.

When db2 is failover server for db2...

Another method is using dtutil Utility...

If your company interested to spend money then there are some third party tools out there for trend analysis and capcity planning...

Otherwise Eric solution is the better one...I use similar...

Run the profiler/trace ...check the output file and delete them if object don't appear in them...

Is the used in linked server configuration's password changed or expired?

And also check the following blog...

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

It was not a question to answer

It was just a news...

You can script the jobs in 2005 and create them in 2000 with that script...

In 2000 you can script all jobs at once but I don't see that option in...

Did you enable mail profile in Mail Session in SQL Agent properties?

I don't think there is any way to move all tables to different tables at once...

You can write a script to move clustered index to different file group which will move...

When you try to append backup to the existing file it failed with "incorrectly formatted" error.

You are trying to restore the db using the same file and getting the error...

I...

Read the following blog/article for your answer...

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/20/trouble-shooting-query-performance-issues-related-to-plan-cache-in-sql-2005-rtm-and-sp1.aspx

http://msdn2.microsoft.com/en-US/library/ms190730.aspx

Transaction log backups of master database are not allowed

http://support.microsoft.com/kb/285288

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