Before we dive into the mechanisms for taking and restoring backups, we need to start with a good basic understanding of the files that make up a SQL Server database, what they contain, how and when they can be backed up, and the implications this has with regard to potential data loss in the event of a disaster in which a database is damaged, or specific data accidentally lost, and needs to be restored.
Specifically, in this chapter, we will cover:
• components of a SQL Server database – primary and secondary files and filegroups, plus log files
• how SQL Server uses the transaction log – and its significance in regard to restore capabilities
• possible types of SQL Server backup – full and differential ...