Not sure I understand your question.

A script of multiple queries will execute sequentially.

Please post new questions in a new thread. Thank you

When you created the SQL logins on the second server, did you specify the same SID and password as the logins have on primary? If not, your database users are...

Having SOS_Scheduler_Yield waits happening doesn't mean that things are waiting for the processor. Having them with long signal waits may do, but the simple presence of the wait does not.

Find the full backup, restore just that with the NORECOVERY option, then restore your log backups. You're getting an error because all you're trying to restore at the moment are...

Nothing wrong with the database then. Maybe someone's been fiddling with permissions. have a chat with your DBA.

Oh you can do a...

Setting min server memory and max server memory to the same value is a bad idea. It disables a lot of SQL's automatic memory management, if the OS comes under...

When you query sys.databases, what is the value of the Status_Desc column for that database?