SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 209 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"

A log restore essentially replays all of
the transactions that occurred. A differential restore, on the other hand, simply replaces
data changes that have occurred since the last full backup. Even a relatively large differential
backup can restore in a reasonable amount of time. A file or filegroup restore can
also speed things along, in some cases, depending on the specific nature of the disaster.
If a disk-array failure holds a subset of data files, you can restore those files alone if
you??™ve backed them up separately.
The most important thing is to try to determine both what the best-case scenario
and the worst-case scenario would be and present them to the appropriate business unit.
Also, use the most conservative estimates you can, but base them on real tests.
Potential Data Loss
???It??™s all about availability.??? This mantra is in vogue these days, but if that were really the
case, you wouldn??™t need to ask how much data loss is acceptable. For a large online
retailer, which is worse? Losing 30 minutes??™ worth of data or being down for 30 minutes?
I would argue the former.


Pages:
197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221