Session 1: SQL Recovery Models and Backups

Presented by: Bradley Ball

Running Time: 59 minutes

This session will answer the following questions: What are full, simple, and bulk-logged recovery? What are the differences between full, transaction log, differential, or filegroup backups? What is a piecemeal restore? What is a stripped backup and how does it speed things up? What is a VLF and how does VLF fragmentation affect my SQL Server? How do VLF’s affect AlwaysOn, mirroring, change data capture, or use transactional replication? This session will cover these topics and more.

 

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish