I??™ll also discuss a number of other feasible
backup techniques. Before getting into specific backup commands, I??™ll clarify a few other
items first:
??? How SQL Server stores information
??? SQL Server recovery modes
??? Backup devices and backup location implications
A Brief Review of SQL Server Storage
To understand the requirements of any SQL Server backup technique, it is critical to
understand how SQL Server stores data and writes it to disk. This is an extremely highlevel
review; we should all know this like the back of our hands, right?
At this point, I won??™t be looking at filegroups; I??™ll cover them in depth in Chapter 4.
For the purposes of this chapter, filegroups don??™t exist. Instead, I??™ll focus on the following
types of database files:
??? Primary data files: Every database has a single, primary data file with the default
extension of .mdf. The primary data file is unique in that it holds not only information
contained in the database, but also information about the database. When a
database is created, the location of each file is recorded in the master database, but
it is also included in the primary data file.
Pages:
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75