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 197 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"

Remember, I??™mnot talking about full disaster recovery planning.
There are two methods to dealing with disaster: mitigating the risk of it occurring or the
impact when it does occur and responding to the disaster. Backup and recovery is a function
of disaster response.
When setting up a backup plan, you need to ask yourself some procedural questions.
Where should I place the backup files? What naming convention should I use? Should I
use single files or backup devices? These are questions that you, as the DBA, must ultimately
answer. I discussed many of the issues surrounding these questions in Chapter 2,
and I provided my biased opinion on how you should do things. However, everyone??™s
environment is unique, and you??™ll ultimately have to decide how you should do things
for yourself.
Some questions have a technical impact. How often should I back up the database?
How much time can the system be down or impacted by running a backup? How much
data loss is acceptable? In the event of a restore, how much downtime is acceptable?
While the answers to these questions ultimately dictate the technical steps you??™ll need to
take and which backup/recovery features you??™ll need to employ, only the business owners
of the database application are qualified to answer them.


Pages:
185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209