Figure 3-7. As long as the SQL Server service account has permission for ???Performance
volume maintenance tasks,??? the database engine can create empty files quickly.
CHAPTER 3 n RESTORING A DATABASE 58
Once you??™ve added SQL Server to this list, you no longer need to initialize every bit in
the file to 0. When SQL Server finally writes data to the file, it won??™t go back and change
bits to 0 for empty spaces??”only the current data is recorded.
nNote You need local administrator rights to grant the right to perform volume maintenance tasks.
Restoring Differential Backups in Simple Recovery Mode
Many DBAs don??™t realize that you can restore differential backups in Simple Recovery
mode. Remember a differential backup is simply the data pages that have changed since
the last full backup. No transaction log is needed:
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWFull.bak'
WITH NORECOVERY -- We aren't done with our Restore process
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWDiff.bak'
WITH NORECOVERY
You don??™t need to restore more than one differential backup; you only need to restore
the most current one.
Pages:
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147