In most environments, Simple Recovery
is reserved for development and quality-assurance systems, as well as for unplanned
backup requirements, such as copying a database to a new development environment or
performing a full backup before making a major change. The following command initiates
a restore in Simple Recovery mode:
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AW.BAK'
WITH RECOVERY
Technically, you don??™t need to specify WITH RECOVERY, because it??™s the default. I
included it here to remind myself that it is the default. If you have the feeling of d?©j? vu,
it??™s because I already said that in this chapter. In my opinion, I can??™t reinforce strongly
enough the need to explicitly specify either WITH RECOVERY or NORECOVERY. Don??™t rely on
default behavior here. Be explicit.
Here I??™m also assuming that the AW.BAK file contains only a single backup file. If you
recall from the previous chapter, you need to append to the existing file (or logical
backup device) when creating a backup. In Figure 3-3, you can see a single data file; the
assumption might be that this file contains a single backup.
Pages:
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142