Microsoft has released a patch to install the SQL Server Service Pack 3 for .NET Framework SDK 1.0 Users.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1C4195CE-4007-476A-AA71-F9782DFD0818&displaylang=en

We perform full NT backup by excluding SQL Server database files (MDF and LDF) and perform database backups to disks and let backup application to pick those database backups to...

What about writing SQL scripts to replace the jobs which were craeted by maintenance plan to perform the same tasks, such as transaction log backup?

Verify whether service "MSSQLServer' is running in the machine.

To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer or OSQL, run...

This wait type indicates that you are waiting for network resources to become available. It mostly caused by either sending large result set to your client or slow network performance.

...

Or try extract this package to another drive.

Any configuration changed to 'max degree of parallelism' recently?

You could write your own script to backup database to multiple files which can be controled to be less than 2GB each. You may end up with many backup files...

Check machine application and system logs.

Try to run DBCC CHECKDB to see if there are any errors reported.

Run UPDATE STATISTICS to your database If there is significant change in the key values in the index...

Does the table have primary key?

Decimal number 128 is equal to Hexdecimal Numner x080.

Check maintenance history to see any errors there.

Any jobs created by maintenance wizard actually is running a DOS program sqlmaint.exe. The program may run endless for whatever reasons so the...

Check KB 246255.

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

Check the status of syscolumns. if status is 0x80, The column is an identity column.