These all sound like interview / homework questions.

If so what do you know about all of the topics you have detailed above.

Unfortunately the full error is truncated from the message.

But as a start the SQL engine account needs access to the share its writing to, to perform the backup.

Check that W2K8SQL\SYSTEM...

The only way would be to test it out, if you know the time for the backup, then you can time the restore on the new server.

There is more to...

Not without asking Microsoft what their timescales are.

Can always keep you eye on http://sqlserverbuilds.blogspot.co.uk/, they are pretty good at keeping the CU's and SP's up to date.

Multiple ways to do it.

Easiest would be to change the source to be a query instead of a table and add in the @@servername parameter

SELECT

col1,

col2,

...

Caveat

As with all things licensing, don't take the public forum as the answer, please go and speak to Microsoft directly or your reseller and ensure you have a written transcript

From...

If you only have backup then there is no way to do it as backups are not downgradable, you can go up versions but not down. So the only...

I would generate the script with all the drops via the "generate scripts" task. Create the database on 2008R2 run the script in. Then generate the SSIS package...

Yes its more of a if I developed a package in VS2012 using the templates downloaded from the link above, will it cause any issues with SQL 2012?

As detailed, I...

Yes it does seem to be a UAC issue, none elevated is deny while an elevated is success.

Potentially

Seems that the standard build gives "everyone" read access to the root of the drive which is removed when SQL changes the NTFS permissions to grant itself access to the...

First of would like to see the execution plan. Appreciate that the query will never finish so the estimated plan will be better than nothing.

Then please provide all of...

As the DB is in no recovery or standby mode you wont be able to alter the file locations without dropping the database.

The only way would be to drop the...

They bot relate to Resource Governor (http://msdn.microsoft.com/en-us/library/ms190382.aspx). If you dont have RG configured you wont get any alerts.

If you want to monitor the actual CPU usage you will want...

Please post the table definitions, index definitions and the actual execution plan for the query. There is a link in my signature on posting code and data for the...