I guess my question would be: why is this an issue? In the report you attached you can see that the SSIS packages are completing successfully so what does it...

the xp_cmdshell statement is executing successfully because it did complete what you sent successfully. You supplied the dtexec command to xp_cmdshell and by virtue of actually running the command it...

I dont think you will be able to change the server collation during upgrade. To change the server collation you need to rebuild master.

http://technet.microsoft.com/en-us/library/ms179254(v=sql.105).aspx

here you go.

http://blogs.msdn.com/b/cindygross/archive/2009/02/22/how-to-configure-dtc-for-sql-server-in-a-windows-2008-cluster.aspx

per core licensing is for SQL 2012. In 2008 R2, per processor licensing is still used. The licensing depends on the amount of virtual cores allocated to the vm and...

I would go with option 2 utilizing a file server.

Option 1 goes against best practice of having your service accounts with limited permissions. If you sql server got compromised...

you could also have...

run this to see what user is being used in xp_cmdshell. This should be the service account of the instance you are connected to. Give this account permissions to the...

check your server configuration options to see if allow updates is set to 1. if it is set it 0

sp_configure 'Allow Updates'

sp_configure 'Allow Updates',0

reconfigure

here an article describing this. I believe...

does your undo(.tuf) file exist and is the creation time consistent with the failed load or the last successful load?

Are there any errors in the sql error log or the...

log shipping secondaries will either be in restoring (norecovery) or standby. Do you set your secondaries to standby (thus restoring is an abnormal state)?

so you can restore the file manually....

you could try restoring the file manually. If it works then that will prove there are no issues with the file. If it fails you may get a different error....

possibly the file \\as2\dbbackups\TransactionLog\ReportOtherCarrierLive\OtherCarrierLive_20131121124501.trn is in use and cannot be accessed by SQL server. You can quickly test this by trying to move(not copy) it to a different folder or...

2013-11-21 13:00:31.95Skipping log backup file '\\as2\dbbackups\TransactionLog\ReportOtherCarrierLive\OtherCarrierLive_20131121124501.trn' for secondary database 'ReportOtherCarrierLive' because the file could not be verified.

This line in the error is where I would start. Do you see the...

awesome, that did the trick and it's cleaner. I was unaware that you could update CTEs directly. Always a bonus to learn something new.

Thanks Luis.