cluster configuration is for server and mirroring is database specific. So failover will be only for a perticular database if you configure mirroring.

have a look of this article

http://www.mssqltips.com/tip.asp?tip=1564

in addition to above suggestion, have familiar with redo and undo process which is part of restoration.

what i am saying is you can have different linked server pointing to same server but linked server name must be different and for all these linked server if...

you can have multiple linked server with same server name but yes their name must be unique. So like server1,server2,server2 but in connection string, it must be pointing to same...

ok what if you configure the same linked server again with different name? you still having the problem after this?

there is difference between 'have one data file' and have one database..

Hope you know both terms

hahahaha............

processing is not related to tempdb only. tempdb is system database

there will be only 1 tempdb like other system database

i dont think history give you information on either the job was called from some other server's job step or its own step.

tempdb get cleared everytime you restart you sql server services.

So by default it get populated with model.

6gb of ram to sql server doesnt mean that tempdb will be of...

Have you checked the job might be configured in some other job as znother step. Not necessarrily to same server but could be calling this job from another server.

what is the failure msg you geting?

Are you running this job under correct operator?

are you getting any kerbos errors in your application log after reboot?

If so you can try to reconfigure your linked server once again after deleting it properly

then you can give reader and writer permission to related login/s for that specific database

have a look of this post. Might help you.

http://www.sqlservercentral.com/Forums/Topic803424-146-1.aspx

Post your problem further if it still not get resolved

what kind of error you getting?

Have you tried by putting the name in [ ] if the name have space or some special characters like '-' or ......