From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Back up very large databases - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Back up very large databases
- [Narrator] Planning for backups is easy when your database is very small. They complete quickly and don't take up much storage space. But when your database is mature and grow to gigabytes or terabytes in size, then backups become an entirely different beast. With the right strategies in place, you can minimize the impact to your databases' operations while still protecting yourself against failure. First, consider the types of backups that you're performing. Make sure that you're taking advantage of differential and log backups to the extent allowable by your business requirements for restore time. Full backups are easy to make and restore from, but they take the longest to complete. As the database grows, you'll want to transition to more of these partial database backups that focus on just the items that have changed since the last full backup was made. Once you start using differential and log backups, you can further save time by limiting the number of changes that occur on the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.