Make sure task scheduler is running on the nodes and nobody is logged in on them - we found these cause problems with installations

:w00t: Probably the best survey I've ever done!

Oh, and I think a peppermint milkshake would be better than an expresso!

I agree with Gail - go for what you know. The performance reports you read from either Oracle or Microsoft on their database products are based on very highly...

It is asking for some windows accounts to use for the services. Are you able create some accounts on the machine you are using? If you are just...

What tool are you going to use to display this data?

Run profiler and use the tuning template to capture the queries being run. Then either pick on the worst performing queries and manually get an explain plan using Management...

You really need to run profiler to capture the queries being run and then determine if there are areas that can be improved such as adding indexes or tuning the...

can you post the full command you are using in the command line

I'd go for erwin or some other db design tool. Visio is excellent for diagramming all sorts of things and is ok if you just want to have a...

Have you run profiler during a period when it is appearing slow? This will show you the queries performing badly and may show the indicate the cause of the...

You can use profiler to capture all queries against the database, this will show who is doing what and you can also add filters so it only shows you the...

I guess the file name/path is incorrect. Maybe it should be F:\mssql\dba\scripts\2000\ResetUsers2000.sql

You can use the 'tuning' trace template in profiler to capture the queries and then you can load the trace file into the Database Tuning Advisor - this may help...

In your command DEL D:\backup\data\SPProd_Cfg _10-19-2008.bak there is a space after the Cfg.

The output you are getting shows it is trying to find two files, spprod_cfg and _10-19-2008.bak; you would...