Creating a recycle bin for SQL Server 2005\2008

  • 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

    zz_RecycleBin.Table1_20110411_1125

    zzz_TrashCan.Table1_20110410_1426

    zzz_TrashCan.Table1_20110409_1735

    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.

    Thanks

    Ant

Viewing post 31 (of 30 total)

You must be logged in to reply to this topic. Login to reply