Use the below mentioned script as first step of your job:

Kill DB Users before restoration

USE master

DECLARE @DB_Name varchar(50),

@SPID smallint,

@msg varchar(255),

@DBID int

SET @DB_Name = 'DBName Here'

SET @DBID = (SELECT dbid FROM...

Permissions required for performing restore -

Server role : sysadmin, dbcreator

DB role : db_owner

http://technet.microsoft.com/en-us/library/cc966495.aspx

MJ

Microsoft SQL Server 2005 - 9.00.3282.00 (X64)

Its:Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2

See-->http://sqlserverbuilds.blogspot.com/

MJ

Have you tried updating statistics?

http://msdn.microsoft.com/en-us/library/aa260645(SQL.80).aspx

MJ

Try specifying a job log file under the job and see if it logs something helpful ovr there.

MJ

Is sql authentication enabled on your sql server?

http://msdn.microsoft.com/en-us/library/ms188670.aspx

MJ

What factors determine the page size?

Fillfactor of the index.

MJ

Set up a profiler trace and filter it for the databases you need to drop and check whether you see any connections for these databases? Do this activity for...

Try specifying max server memory to 2GB and see how it goes.

MJ

What do you get in output when u run:

select name,is_broker_enabled from sys.databases

where name='DatabaseName'

MJ

What error do you receive when you try to drop it?

MJ

Read about it at http://www.db-staff.com/index.php/microsoft-sql-server/69-change-collation

MJ

COnnect by specifying port and IP address in format:XXX.XX.XX.XXX,PPPP

MJ

a) Same as Sleeping, except Dormant also indicates that the SPID has

been reset after completing an RPC event. The reset cleans up

resources used during the RPC event. This...

When using Windows Authentication, if the server instances use different accounts, specify the service accounts for SQL Server. These service accounts must all be domain accounts (in the same or...