I would like to thank Chris for this, it is excellent.
One question I have is how do you "UNDROP" from trash can.
Say we have 3 copies of the same table
The first two we dont need to recover but we need to recover zzz_TrashCan.Table1_20110409_1735, other than scripting the table and then moving the data is there another way.
How to post data/code for the best help - Jeff ModenNeed a string splitter, try this - Jeff ModenHow to post performance problems - Gail ShawManaging Transaction Logs - Gail ShawTroubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger