Try to run dbcc checktable to 'dtproperties' table in the database you received the error message to see what will you get.

That is because you are runing the standard edition.

Can you send back the result of following commands? Please also post your insert statement.

use tempdb

go

sp_helpfile

go

dbcc sqlperf(logspace)

You don't have to backup the tempdb at all.

Microsoft has a tool to handle such request, Search Microsoft SQL Server website.

Also try to update tables/indexes statistics to see whether SQL Server runs the SP using multiple processors.

I would try to find out which part of SP running slow and compare...

http://support.microsoft.com/default.aspx?scid=kb;en-us;304261

http://support.microsoft.com/default.aspx?scid=kb;en-us;841696

http://support.microsoft.com/default.aspx?scid=kb;en-us;812504

Can you please the link to your script. Thanks.

Are SQL Server 2000 running as named instances?

Try

dbcc rebuild_log ('Training', 'c:\Training_Log.ldf')

I think you are in right direction to look into the SP.

Adjust number of CPUs for paralleism could affect some of queries, You need to monitor them clolsely. But in...

Are you saying you were asked to downgrade SQL Server 2000 database into SQL Server 7.0? Curious why if it is?

You can't restore SQL Serevr 2000 database into SQL Server 7.0!...

Sounds like blocking, run sp_who2 to see when you notice slow performance.

Backup your original database and restore it into destination server without recovery, then continue the log shipping.

You can't. Call your DBA or reset it if you have the permissions.

What exactly did you look for?

In term of restarting servers, Don't restart both servers at same time, Always wait until restarted server is online before restarting another one.