When working with databases, we always need to have an ability to recover them when some 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 and also in stressful situations when some corruption occurs. Who knows syntax is never lost in dialogs of the SQL Server Management Studio.
In the introduction, internal data handling was described. This knowledge is an advantage not only when performance backups and restores, but also for better understanding when we are going to optimize a database.
The second part describes backup capabilities of on-premise SQL Server instance. The third part shows how to used backups to...