SQL Server is trying to start the services by using 'AGTACCOUNT' Account and It looks like windows service account is not properly created.

what error is setup log is showing ? You can find the error at location: %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

It is possible using trace as well in 2000.but in 2005 default trace is already running.by using below command you can find our SELECT *

FROM fn_trace_gettable

('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc',...

Yes you can install one more instace or upto 16 instances and use whateever cluster group you want.Basically Cluster group is considered a group where all the drives are...

Select * from table1

Lock is usual activity on the sql server.SQL Server implements lock serveral time depending upon the priority and type of transaction.Deadlock is the process where you find two or more...

It depends on the configuration of the server like processor sped ,RAM,64 or 32 bit OS.etc.it is even ard to estimate

Yes you can connect to the sql server provided you configure link server .refer BOL has for Link server configurations.

1.Shrink the log using DBCC Shrinkfile

2.Backup log with truncate only option.

Yes you can install SQL2k and SQL2k5 on one cluster be sure you keep the instance name different.

What SQL Server version adn patch level you are working on?

Is this the maint plans for SQL 2000?

It looks like this is Instance name.Did you reinstalled the server?

The ServerName property provides the Windows NT server and instance name that together make up the unique server instance. @@SERVERNAME...

can you elaborate some more on what uyou are looking for?

If it is not a cluster you can change by following below steps:

sp_dropserver old_name

GO

sp_addserver new_name, local

GO

Check the log during backup job which process is overlapping.

Also the backup size may be large enough to fit in your tape drive.