• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

Point in time recovery question with simple recovery model

I have some databases that are in simple recovery mode.  I have an application that is setup to backup transaction logs.  Another dba claims he restored the database to a specific point in time with the recovery tool from the backup software.  this backup software relies on api's provide by sql server.  I believe my counterpart but am confused as to how this might be possible.  sql server 2008 btw
0
jamesmetcalf74
Asked:
jamesmetcalf74
2 Solutions
 
ste5anSenior DeveloperCommented:
When you have a full or bulk logged database, then you can restore from the transaction log backup up to a certain point of time by specifying a STOPAT value. See also The role of STOPAT in RESTORE DATABASE.
0
 
Scott PletcherSenior DBACommented:
>> I have some databases that are in simple recovery mode. <<
>> I have an application that is setup to backup transaction logs. <<

Those are contradictory.  SQL Server doesn't allow log backups in SIMPLE recovery; logically enough, since such files would be useless as they can't be applied to a db restore anyway.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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