Showing posts with label whentia. Show all posts
Showing posts with label whentia. Show all posts

Tuesday, March 20, 2012

Restore Rows from Table

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.)
|||> 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.)