CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 147
Potential Limit to Database Size
When I??™mdefending log shipping, people often argue, ???It just won??™t work for VLDBs.???
There??™s some validity to that statement, but only during setup or a reset. Log shipping
requires a full backup from which to start, so sizeable databases are difficult to transfer
over to a secondary server. From that point on, the only size consideration is how large
the transaction logs are. You should be backing up the transaction logs frequently, so
size shouldn??™t be an issue.
Of course, this does assume that you have capacity on your standby servers to handle
a sizeable database. Keep in mind that for every standby server, you??™re storing a
complete copy of the database.
Failover
Failover and failback (which I??™ll discuss next) are the true limitations to log shipping.
When something goes wrong and you need to fail over to the standby server, roll up your
sleeves??”that failover is a manual process. I??™ll cover the exact process shortly, but the
main point here is that failover is manual.
Pages:
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299