Enterprise Data Management - LogShipping

Add to Favourites
Post to:

Log shipping is a robust and reliable high-availability disaster recovery and reporting solution that can be implemented very easily with the hardware you already have; there is no need to purchase any new costly hardware. Log shipping backs up the transaction log on the primary server every few minutes and restores it on the warm standby servers. If the primary server stops working, you can make one of the warm standby servers your new primary server. The main problem with log shipping is that the role change is a manual process and the DBA needs to be present to execute it. It is possible to automate most of the role change process using SQL Server Agent jobs, but some manual intervention is still required and the clients have to be manually redirected to the new primary server.

Type: ppt

IT Expert
DBA Oracle Certified Professional , LINUX, C , C++,O/S ,NETWORKING, SE
65 Members Recommend

Your Facebook Friends on WizIQ

Explore Similar Courses