A great query for finding this dropped table is this:
SELECT *
FROM
fn_dblog (NULL, NULL),
(SELECT
[Transaction ID] AS [tid]
FROM
fn_dblog (NULL, NULL)
WHERE
[Transaction Name] LIKE '%DROPOBJ%') [fd]
WHERE
[Transaction ID] = [fd].[tid];
This will return back everything you need to get this table off of your backup:
[Current LSN], 3 [Operation], 4 [Context], 5 [Transaction ID], 6 [Description]
No comments:
Post a Comment