I'd like to know if its possible for SQL to capture deadlock information (using DBCC Trace 1204,1205) when restoring a database using both full backup and a series of transaction logs. I've backed up a database that contains production deadlocking events. By applying the transactions logs up to the time deadlocking has happen ontop of the full backup, will SQL capture and write this information to the SQL logs?
I'm using this method to see if making various Hardware and SQL configurations will help out.
Appreciate responses