Do you get any type of message when you try to connect to SSMS? Please post any and all messages.

With the use of the AWE enable option, SQL Server 2000 can use up to 4 GB of physical memory.

Please review the following link, it lists all SP and patches

http://sqlserverbuilds.blogspot.com/

Hope this helps

Can you post the results to the following:

SELECT * FROM msdb.dbo.sysdbmaintplan_history

This will give you a much greater detailed message as to why the job is failing.

What you are reading is "best practice" and what I like to call the "dream scenario" installation. I too have worked for many years with the smaller mom and pop...

Please review the following article by Joe Webb

http://weblogs.sqlteam.com/joew/archive/2008/01/14/60456.aspx

Neither will truncate the Transaction Log. To do this, you would need to perform a Transaction Log backup and then you can truncate the log file, but keep in...

Do you ever receive an error message or a dialogue box or time out? What about the event log, can you see anything in there, is it possible to...

The 3:08 a.m. time stamp is the time that the 2:00 a.m. Transaction Log backup finished, and thus over ran the 3:00 a.m. scheduled backup.

More than likely you...

There isn't any one site that shows OS then SQL version. The link below is for SQL 2008, and then just to the right at the top of the...

Have you looked into any 3rd party applications? There are quite a few out there, but the one we have most recently started using is Apex SQL Diff

I wasn't the best of help on your first question, so let me try to make it up. The linked server information, along with Maintenance Plans and SQL Agent...

If I am understanding your question correctly, you would click on Options from the initial "Connect to Server" login. There on the "Connection Properties" tab you would change the "Connect...

Have you looked in the Articles section of this site? There are numerous, well documented steps and checks like the one written by Banyardi Schmardi linked below:

http://www.sqlservercentral.com/articles/SQL+Server+2008/67066/

I doubt you...

Just throwing this out there, are there any OLE DB Linked Servers?

The vendor application you mentioned, is it performing a bulk insert?

Can you post the error log?

How much memory do...