CHAPTER 3 n RESTORING A DATABASE 53
Figure 3-3. This dialog appears when selecting a source from which to restore.
As you can see in Figure 3-4, however, a single file may actually contain multiple
backups.
If you store multiple backups within a single file, you must specify the number identifying
the backup that you want to restore; otherwise, the restore attempt will fail.
CHAPTER 3 n RESTORING A DATABASE 54
Figure 3-4. The backup file contains more than one distinct backup, so you have to choose
which one to restore.Make sure you know which file you want before continuing.
Restoring in Full Recovery Mode
In most cases, you??™ll be dealing with databases in Full Recovery mode. This can complicate
the restore process immensely if you want to restore as much data as possible. You
need to include the full backup, any differential backups, any log backups, and the tail of
the transaction log.
One of the most common mistakes users made with SQL Server 7 or 2000 was forgetting
to back up the transaction log before beginning a restore. The tail of the log contains
any transactions that occur after the most recent backup (full, log, or differential).
Pages:
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143