scroll to top
Stuck on your essay?
Get ideas from this essay and see how your work stacks up
Word Count: 984
The concept of standby servers is not a new one It has been around a long time and been used by many DBAs Traditionally using a standby server for failover has involved manually making database and log backups on the production server and then restoring them to the standby server on a regular basis This way should the production server fail then users could access the standby server instead and downtime and data loss would be minimized What is Log Shipping Essentially log shipping is the process of automating the backup of database and transaction log files on a production SQL server and then restoring them onto a standby server This in effect keeps the two SQL Servers in synch Problems with Log Shipping log shipping is a compromise It is not the ideal solution but it is often a practical solution given real-world budget constraints Some of the problems with log shipping include Log shipping failover is not automatic The DBA must still manually failover the server which means the DBA must be present when the failover occurs The users will experience some downtime How long depends on how well you implemented log shipping the nature of the production server failure your network the standby server and the application or applications to be failed over Some data can be lost although not always How much data is lost depends on how often you schedule log shipping and whether or not the transaction log on the failed production server is recoverable The database or databases that are being failed over to the standby server cannot be used for anything else But databases on the standby server not being used for failover can still be used normally When it comes time for the actual failover you must do one of two things to make your applications work either rename the standby server the same name as the failed production
@Kibin is a lifesaver for my essay right now!!
- Sandra Slivka, student @ UC Berkeley
Wow, this is the best essay help I've ever received!
- Camvu Pham, student @ U of M
If I'd known about @Kibin in college, I would have gotten much more sleep
- Jen Soust, alumni @ UCLA