Tuesday, May 24, 2011

Log Shipping


What is Log Shipping

Log Shipping is one of the methods for creating a Standby server, by god forbiddeen if something happens to our production server we need a standby server and Microsoft has come up with this idea and introduced Log Shipping in SQL 2000 itself. But in SQL 2005 it has been enhanced further by making it more user friendly. It is mainly used in OLTP environment (Online Transaction Processing). It is used as a High Availability Solution and also in Disaster recovery situations.

Overview of Log Shipping

Let’s discuss the overview of log shipping. The basic idea is nothing but backup and restore of the database and transaction logs sequentially from the primary server to secondary or standby server. We might be having some extremely critical databases in our production environment and need them to be online 24*7.If the production server is down due to some natural disasters or in some cases we need to reboot the server after applying some service packs or in case of some hardware upgradation i.e adding extra hard disks, all those require some downtime of the production server in that case we can make use of log shipping.

No comments: