MS SQL Point-In-Time Recovery from offline backup
Posted on 2014-12-30
If I have a snapshot backup or "offline backup" of MS SQL 2008 R2 @ 11pm every night. We also plan having transaction log backup running every 2 hours - it is possible to achieve point-in-time recovery by restoring the offline backup, start in recovery mode and apply transaction log? Any special steps required?