Please check...

The output says so.

D:\\audittrace_20110207135814

As per the output the C2 audit trace is still running. After disabling it, the SQL Server service needs to be restarted in order for the changes to take effect.

Check if it was enabled for any legitimate reason. Disabling it would not damage anything. C2 audit will continue to run until the drive hosting the trace file gets full....

You can check it through sp_configure or through SSMS GUI as in the below screenshot.

Please check if you have C2 Audit enabled on the instance.

The following message is seen in the SQL Server Error Log.

2011-02-03 19:31:25.11 spid7s The resource database build version is 10.00.1600. This is an informational message...

Please check the entries in System/Application event log, SQL Server Error Log for the possible reasons for the SQL Server service not starting up.

I just responded to a similar question here. You may find it useful.

If you are migrating the user databases to a new SQL Server 2008 instance, you can script the logins on the SQL Server 2005 instance using sp_help_revlogin and execute the...

Not sure why you would want to do this since these roles are created when you install SQL Server. However, you can find the script to create these roles ...

Check if sp_helprotect meets the requirement. Here is an example.

sp_helprotect 'xp_fixeddrives'

Since you are upgrading, the setup would take care of transferring the logins to the upgraded instance. However, before performing the upgrade make sure to have FULL backups of all...

You can make use of SQL Server 2008 Upgrade Advisor to look for any possible issues, before actually upgrading the instance. You may find this article useful.

Here are my recommendations.

1) For rebuilding the indexes the scripts found at http://ola.hallengren.com/[/url] are very useful.

2) You may make use of Poweshell to capture Performance Counters. Here is an example.

3)...