This isn??™t quite a point-in-time recovery, but it does allow you to get
to a much more current state than the last full backup. Again, I still haven??™t recovered the
database. If you were to look at the database in Management Studio, you would see that
it??™s in a loading state. To bring it online, you just need to perform a recovery:
RESTORE DATABASE AdventureWorks
WITH RECOVERY
The database is now online and available for users. I generally like to keep the recovery
process as a separate action.
Restoring Differential Backups in Full/Bulk-Logged Mode
Differential backups in Full Recovery or Bulk-Logged Recovery mode behave exactly
the same as if they were in Simple Recovery mode, except that you will receive the taillog
error if you try to overwrite the database and restore just to the last differential. You
can force an overwrite if you really want to restore just the full and the differential
backup, but I??™ve never seen that technique in action. Instead, you can start restoring
transaction logs.
CHAPTER 3 n RESTORING A DATABASE 59
nNote Did you remember to use WITH COPY_ONLY? Differential backups are tied to the last full backup
that occurred.
Pages:
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148