It is
possible to obtain a relative balance between these constraints, but that usually means
increased cost.
Time to Back Up
Even though backup operations are online, they still have a performance impact on a
database. SQL Server 2005 improves on that speed by leveraging multiple processors
whenever it can, but a heavily used database will most likely see some sort of performance
hit when a backup occurs.
If the business requires optimal 24x7 performance, you??™ll need to take that into consideration
when choosing your backup scheme. This does not mean that you??™ll necessarily
need to restrict which backup methods you use; instead, it only indicates that you
must take the performance impact of any single backup into account.
Ideally, you??™ll have some leeway when determining the optimal backup scheme. In
many situations, the database is already in production, so experiments with backups
could have serious repercussions. If the system is already in production, be sure to inform
the appropriate business unit of a possible performance impact when you test a specific
backup technique.
Pages:
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218