However,
once you start including multiple files to restore (differential and log backups), the
potential for an unwanted or unexpected restore surfaces.
CHAPTER 3 n RESTORING A DATABASE 44
Recovery is an option for a RESTORE statement. If I??™m recovering the AdventureWorks
database from a full backup and don??™t include the RECOVERY option, the operation will
default to WITH RECOVERY. The GUI presents the same default, as shown in Figure 3-1. Be
careful only to use the first option (RESTORE WITH RECOVERY) if you??™re sure that no further
restore operations are required.
Figure 3-1. The default RECOVERY option as displayed on the Options tab of the RESTORE dialog
box in SQL Server Management Studio (SSMS)
If you accidentally leave the RECOVERY clause out of a BACKUP statement or quickly go
through the GUI to do a restore, you??™ll have to start over if you were supposed to include differential
or log backups. While that might not seem like an earth-shattering development, go
back and reread the second paragraph of this chapter. No matter how large or how small the
database is, if the business feels it is important, there will be pressure and stress.
Pages:
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125