No there is no metric, it takes as long as it takes.

Depends on access methods, server load, blocking, locking etc.

What authentication method do you use for the applications? Windows or SQL?

Will there be a two way trust in place between the domains?

Do you use hostname or...

Personal preference is to always backup to local drives first then use something like robocopy to make a copy to the network share.

I say this as if the network blips...

You dont need profiler to find the execution plan.

You just need to use 2 DMV's to find the plan from the system tables or 3 if you want the SQL...

You are trying to find out who ran that query a number of days ago. You cannot do this, there is no history table.

Sys.dm_exec_query_stats is just what it says,...

You would need to create some custom logging in the form of a login trigger, which inserts into a table when a user logs in.

From there you could link it...

Without some custom auditing or a trace that was running at the time you wont be able to find that information.

There is no historical table which logs who ran what...

do you have any logging in the package?

if so can you not query the sysdtslog90 table and see whats going on?

I am at a loss.

Out of interest what are the editions and product levels of all servers in the UCP environment?

Mix of 2008 and 2008R2 and 2012 with which SP's...

Size depends on envrionment, my TempDB is 45GB, 1MDF 3NDF's at 10GB and the LDF at 5GB, never go above 10% utilisation but there have been times which the TempDB...

without a more detailed error, we cannot say what causes it to fail on the scheduled run.

join sys.dm_exec_query_stats onto sys.dm_exec_requests on either the query_hash or query_plan_hash columns

then join sys.dm_exec_requests onto sys.dm_exec_sessions on the session_id columns and username hostname application are in that one DMV

Only thing I can find is that the SQL Agent must be configured for Manual starting when on a fail over cluster. Is this the case on your environment?

SELECT * FROM sys.messages WHERE message_id = 37007 AND language_id = 1033

Google the "DISKPART" dos commands and you can do it via windows without needing to purchase any software.

So if you have 1 drive split 50GB C 100GB D then you...