Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

differential backup

I am a new sql administrator and I was wondering if it is possible to restore a particular transaction from a differential backup.  Thank you!!
0
asys016
Asked:
asys016
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
It is not possible to restore a particular transaction from ANY kind of backup...
The only think you can do is, using transaction log backups, restore up to a given point in time.
In Oracle, i have seen the option using a build-in LogMiner tool to analyse the redo log files, being able to read the undo and redo statements, but not in SQL Server...

Cheers
0
 
CleanupPingCommented:
asys016:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
arbertCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept AngelIII's comment

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Arbert
EE Cleanup Volunteer
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now