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?
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed