For a full restore, there is no difference in behavior from
that of a database in Full Recovery or Simple Recovery mode.
Restoring/Moving to a New Location
Another common mistake made by new DBAs (and sometimes experienced ones) is the
method for restoring a database to a new location. To do this within the GUI, you have to
go to the Options page during the restore process, as shown in Figure 3-6. Notice the
browse button next to the items in the Restore As column. If the database files need to
reside in a different directory structure, you??™ll need to specify it. With SQL 2000 and earlier,
you needed to actually type it out. The browse button is another nice addition.
CHAPTER 3 n RESTORING A DATABASE 56
Figure 3-6.Moving files under the Restore As column
Of course, I prefer to use a restore script rather than the GUI. In the rush to begin, it??™s
tempting to click OK without checking all of the settings. Keep in mind that you??™re giving
the logical name of the file to be moved and the physical name of the new location. The
key clause when moving data files is WITH MOVE??”for example:
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AW.
Pages:
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145