O'Reilly logo

SQL Server Backup and Restore by Shawn McGehee

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 1: Basics of Backup and Restore

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required