Hmm..

You may want to look into next performance degrading areas:

- Locking/blocking issues as a result massive select, insert, update, delete operation

- Tempdb files space issue

- Database log...

You may want to see this info first:

http://www.sqlservercentral.com/Forums/Topic337658-149-1.aspx

The message means a connection to a database was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of...

Linked server is a simple way, but it is not the most secure way in serious production environment, because normally every server has own set of the users, admins,...

I can see several reasons for this error message:

1. Backup file is incomplete or it is just part of stripped backup set.

2. Backup file corrupted by antivirus software during the...