Assuming Sales database has one mdf with name is sales_data and one ldf with name sales_log

use following command pattern to accomplish your requirement:

restore database Sales_Readonly from disk='specify bak file...

Can you post output of :

DBCC SQLPERF (umsstats)

An additional thing, Since you have 16 CPU on that box so you should configure 352 worker thread (per MS)

It indicates that you have not stopped trace and trying to copy file. To verify this run following query

select * from fn_trace_getinfo(default)

you need to stop trace before you copy...

Yes, It is possible to select space between two words.

This error indicates that system is running out of virtual memory. My suggestion would be to check RAM.

Good to learn its resolved. 🙂

Did you try stopping full text service and then performing delete index thru SSMS?

Please explain what behavior you are referring to.

hmmm same hpnd with me once and when I tried experimenting in detail I found it happens once you try to process more than 9 gb file. Weird but no...

I think you are using different user for both jobs. Please verify whether user used in failed job has proper access.

Which version of SQL Server you are using?

You need to impersonate an id that can allow other user to access link server. You need to set this under Security tab of your linked server properties.

You can either...

Yes, you can use it but downside is that, because the statement does not issue any locks against the tables being read, some "dirty," uncommitted data could potentially be read.

Good to know you resolved it.

If existing data and log files for all databases are ok then You should use data and log files for system databases after installing sql server provided you are installing...