Ofcourse. I just missed it while copy-paste. As i said the question was i wanted to trace what transactions/sp cause deadlocks on my server. What could be the best possible way...

Oops i missed it.

Events: Lockdeadlock & lockdeadlock chain

Datacols: event class, start/end time,object id, object type,spid,host,text data

But that lists out everything including sleeped users. I am more interested to know what are the users that are currently actively connected to my server.

Its the default of -1. I just want to setup deadlock alert. Can you show me how i can do this??

I forgot to mention:

I did all these settings on Server A, Restart DTC,SQL Agent and reboot the system as well.

One more thing server A in win 2003 & server b...

Probably i would like to do this thru performance monitor alerts. Any idea?

Full Backup:

BACKUP DATABASE [ABC] TO [ABC_BackUp] WITH  INIT, NAME = 'Full Bkp'

Verify Backup:

RESTORE VERIFYONLY

FROM DISK = 'F:\Database Backup\User Databases\ABC\ABC.BAK'

Above is the backup script, sometimes the full backup takes very long...

My backup schedule is full-diff-tlog bkp. Sometimes my Diff backup takes long time and resulting error: error in reading bkp device. I don't understand why this happens.

Thanks. The job x is actually a backup job which need to restrict to 60 mins.

Thanks for all your efforts.

I mean to say what we need to look for. It simply gives the sequence of backups created as similar to ;RESTORE HEADERONLY FROM ABC_BackUP? Also what could be the...

Further, one thing i need to mention that during that day the TLog backup failed once but on its next run it succeeded. See the error below when it failed;

I checked the log but could not find any info. Also the table backupset doesnot give much help.

I have corrected. It was typo.

I even tried recreating the whole bkp and this time again i could not restore file 4 (TLog bkp file). I checked all truncate log is never runned. Why i...