What is Log Shipping and its purpose
Posted on May 22nd , 2009 by Admin
|
|
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. In Log Shipping the transactional log file from one server is automatically updated in backup database on the other server and in the case when one server fails the other server will have the same DB and we can use this as the DDR(disaster recovery) plan. it will automatically backup transacti |
| on logs throughout the day and automatically restore them on the standby server at defined interval. |
|
|
