Q:  What is log shipping?

Bryan Oliver says:  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. But this is not all. The key feature of log shipping is that is will automatically backup transaction logs throughout the day (for whatever interval you specify) and automatically restore them on the standby server. This in effect keeps the two SQL Servers in “synch”. Should the production server fail, all you have to do is point the users to the new server, and you are all set. Well, its not really that easy, but it comes close if you put enough effort into your log shipping setup.

Microsoft support Log shipping only in the enterprise edition
Quest supports Log shipping in all versions of Lite Speed

Technorati Tags:
Log Shipping, SQL Server, transaction logs, standby server, Microsoft, LiteSpeed for SQL Server
Add to: | Technorati | Digg | del.icio.us | Yahoo | reddit |