Summary

When working with databases, we always need to know how to recover them when damage occurs. This chapter was intended mostly as a syntactical guide for correct backup planning and performing for several types of databases, such as OLTP user databases, big databases, and system databases. A GUI alternative is also possible, but using syntax is a better approach when automating backup tasks when some corruption occurs. Syntax is never lost in dialogs of SQL Server Management Studio.

In this chapter, we learned about internal data handling. This knowledge is an advantage not only for backups and restores, but also for a better understanding when we cover optimizing databases.

We also learned about the backup capabilities of on-premises SQL Server instances. Through examples, we understood how to use backups to restore databases in many scenarios. We also learned the impact of backup procedures already being used on restore abilities that are measured by the RPO and RTO criteria...