)
Restoring to a specific point does have implications. You can??™t apply any additional
backups after a point-in-time recovery. Also, restoring log backups takes much longer
than restoring a differential or even a full database backup if the log restore started from
day one. A full restore replaces data pages, whereas a differential restore replaces pages
that have changed since the last full backup. A transaction log restore literally replays the
transactions that have occurred. Given the amount of transactions to restore, the process
can take an unacceptable length of time. I??™ll talk more about optimal backup/restore
plans in Chapter 5.
Time
Usually a request comes in to restore the database to a specific time. For example, ???Soand-
so accidentally deleted two million records, and we need to restore the way the database
looked at 3:10 p.m.??? As you??™ll see in Chapter 9, there is another way to handle this.
Restoring log files is actually a separate command, but it??™s similar to the RESTORE
DATABASE command. It does require that a full database restore and a differential (if
needed) occur first.
Pages:
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150