Even I am affluent with the GUI only, however check the below article posted on sql server central that can help further on this.

http://www.sqlservercentral.com/articles/Administering/howtoscheduleasqlserverdatabasecreationscript/1834/

Meanwhile we can also look...

I echo Jack...this can be acheived for SQL Server as a whole by setting the "priority boost" to high, but not for individual spid's.

-Rajini

The easiest way is to find it through job history..

Message

The Job was invoked by "the person or the account"

Try restoring the database using the following query:

restore database "dbname"

from disk = 'Servername\sharedlocation\db.bak'

servername - This is not the local server name, it is the servername where the backup files are...

Hi,

Please follow this following steps:

1. Use sp_who2 to check for the user currently connected to the db and kill the spid accordingly, it shloud not even be in the sleeping...