September 16, 2010 at 12:26 am
Hi All,
considering a senario, some one mistakenly delete 100 records from a single table let say Table A.
we dont have multiple filegroups here, just one filegroup that may have 100 tables.
now what best we can do to get these records back ?
is there anyway we can only restore Table A's data with point in time recovery ??
or any other option ?
September 16, 2010 at 12:33 am
Simplest way is to restore the most recent backup of the db to another database, then re-insert the accidentally deleted rows.
Insert into .. select from is a very useful construct.
Mike
September 16, 2010 at 1:11 am
@ MIke : yes you are right , i know this methode but this way we have to restore full database. i was asking is there any other way to do it ?
September 16, 2010 at 1:14 am
Point in time restore via logfiles is about it.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
September 16, 2010 at 3:42 am
Craig Farrell (9/16/2010)
Point in time restore via logfiles is about it.
can you please elobrate or give me any link for it
i wana try
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply