DBCC CHECKDB uses an internal database snapshot to prevents blocking. However as mention by Gail provide the detail deadlock chain/graph for further investionation.

Did backup configured through maintenance plan? If not create it with maintenance plan and check.

As mentioned in the error there are issue with the said index drop the index and recreate it later after changing the collation.

If you are getting multiple this kind...

Interesting question, thank you Andy.

Thanks for QOD, Barry.

Check the permission for linked server for specific login which you are using to access data.

Are you able to execute any other command for that linked server?

It looks like before Log shipping restore the backup file it is deleting. Hence this is having issue. You can increase the backup retention time to 48 or 36 and...

Easy one!

Thanks.

Have you checked the query plan? Can you share the query plan too?

It may take little long compare to Mirroring. However check if any blocking or anyother issues on the server. Check for any error message for further indication.

Beatrix Kiddo (6/12/2014)

---

Your systems/SAN/infrastructure whatever you call them team may well have decided to take your SQL backups for you. They sometimes do this :-D.

Under these circumstances you need to...

Nice one thanks Steve.

It depends on what is the purpose. If you would like to restore point in time or all the current transaction which is not backed up in your current T-log...

Is the hardware configuration of prod and test are same?

Run update statistics or Reindexing on the database and re-play the production load.