BAK'
WITH MOVE 'AWData1'
TO='E:\SQLData\AWData1'
MOVE 'AWLog1'
TO='F:\SQLLog\AWLog1'
WITH RECOVERY
Note again that I explicitly included the WITH RECOVERY clause, even though it??™s the
default. Try to get yourself in that habit??”it can be a lifesaver.
CHAPTER 3 n RESTORING A DATABASE 57
nTip The directory structure must exist in order for WITH MOVE to work. SQL Server won??™t create directories
automatically.
Restoring with Fast File Initialization
When restoring a large database to a new location, simply creating the data files can consume
a significant amount of time, because Windows is initializing the file and setting all
the bits to 0. If you??™re running SQL Server 2005 on Windows Server 2003 (or Windows XP,
if it??™s SQL 2005 Express Edition or Developer Edition), you can take advantage of instant
file initialization. With this feature, files are created without setting every bit to 0. The
impact on creation speed is astounding.
You must give the SQL Server service account the ???Perform volume maintenance
tasks??? user right, as shown in Figure 3-7. By default, only local administrators have this
right, which can be found under the Local Policies ?¤ User Rights Assignment.
Pages:
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146