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

James Luetkehoelter

"Pro SQL Server Disaster Recovery"


Multiple Standby Servers
One of the often overlooked benefits of log shipping is that there is no limit to the number
of standby servers for one primary server. You could have standby servers all over
the world, mitigating some of the worst environmental disasters imaginable, which
we??™ve unfortunately seen in the last few years with Hurricanes Katrina and Rita and the
massive tsunami in the Indian Ocean. Log shipping is a loosely coupled technology, giving
it the unique ability to use multiple standby servers. Figure 6-2 shows a multiserver,
log-shipping deployment.
Imagine the level of low-cost data protection you can achieve by using multiple
standby servers in multiple locations. No fancy, expensive geo-locating SANs are
required. The network infrastructure is already there, and you can secure the transfer of
data with existing protocols, such as HTTP over Secure Sockets Layer (SSL), known as
HTTPS; File Transfer Protocol over SSL (FTPS); and Secure File Transfer Protocol (SFTP).
If something fails on the primary server, you??™re most likely to lose data. Each standby
server might be at a different state, so it could take awhile to find the most likely candidate
to perform a failover if necessary.


Pages:
279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303
druga wojna światowa Free English grammar and study guid hotel jelenia góra Russian bride counter strike 1.6