Is it possible to restore certain Rows from a backup to a specific Table?
Also, is there a log to determine which Rows where deleted when?
TIA,
--
Brandon Moser
Marketing & Systems
Spence, Driscoll & Company, Inc.
bmoser@.(nospam)spencedriscoll.com>Is it possible to restore certain Rows from a backup to a
specific Table?
Not unless you have done filegroup backups. You could
restore the whole db to another name, then extract the
data you need.
>Also, is there a log to determine which Rows where
deleted when?
>
The only thing Ive heard of is Log Explorer from Lumigent.
>--Original Message--
>Is it possible to restore certain Rows from a backup to a
specific Table?
>Also, is there a log to determine which Rows where
deleted when?
>TIA,
>--
>Brandon Moser
>Marketing & Systems
>Spence, Driscoll & Company, Inc.
>bmoser@.(nospam)spencedriscoll.com
>
>.
>|||> Is it possible to restore certain Rows from a backup to a specific Table?
No. You can't even restore an entire table on its own, unless you have
performed individual filegroup backups and the table lives on the filegroup
by itself. You could restore the backup to another instance, then copy out
the rows you want.
> Also, is there a log to determine which Rows where deleted when?
http://www.aspfaq.com/2449
--
http://www.aspfaq.com/
(Reverse address to reply.)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment