If you did backup and restore instead of copy, you would not have this problem.

As the error indicates, bcp cannot find the server in the server\instance string in the -S switch.

If the server is correct, I would wrap the string in double quoutes ("),...

Is PurchaseOrderDetailID the clustered key?

If it is, is it necessary to have it in the include statement, since the clustered key is always a part of a non clustered index...

Look at the job history.

Check what user executed the job step (likely whatever user that is running the SQL Agent Service)

make sure that user has the appropriate permissions.

You also need a strategy/process for syncing up database logins between the two sites.

And if you use SQL logins, then you need scripts/processes that sync up the database users associated...

Create date/time of the physical file?

In Powershell:

$(get-childItem '<file_name_or_path>').CreationTime

Any create or drop of an object should be in the default trace.

Do you have the default trace file(s) for the time in question?

Not sure if rename of an object...

In both cases there is an earlier data modification within the transaction (X lock), then when the batches with the select try to get a shared lock on the resource,...

If either of these suspended sessions had an open transaction in tempdb (i.e. related to a temp table), then the tempdb log would continue to grow until these transactions were...

What is the structure of the ENGINE_ENTITIES table?

What does the select look like?

What is holding exclusive locks on the table?

The selects are trying to bet a shared locks on the table but each session is holding earlier exclusive locks within the transaction.

Transaction count is 1 on both sessions. What else is happening inside these transactions?

is there an exclusive lock on some record(s) in the table that gets hit by the...

These instances may still be default instances, but not listening on the default port with SQL browser turned on.

That being said, in order to administer a SQL server instance you...

Jeff, that is an awesome example of using format files with BCP in SQL server.

In the past I have only used bcp format files with Sybase BCP.

Another option is to...

What type of storage do you have?

Thin provisioning?

Did you see disk queues go up during these events?

Does it happen on the same days of week/time of day?

Any maintenance going on...