Share This :)What is Log Shipping?
Log Shipping is a automating the backup and transaction logs in Production server and then backing up or transferring it to another SQL Server. The Log Shipping will backup your valuable data on to standby server on specified interval.
Why Log Shipping?
To to be in safer side. Who knows when you see the BSoD (Blue Screen of Death). You may encounter hardware / software failure in your Production Server anytime. This Log Shipping will save your time, your company money!, some time your JOB tooo…!. if your both Servers encounter same failure then…. I’m sorry!
For more Detailed article click here
SQL Server Performance
NOTE: Only Enterprise and Developer editions of SQL Server support log shipping.
How It Works?
Log shipping implementation is straightforward:
1. Full backup of the database is taken on the primary server and copied to the standby server.
2. Standby server maintains a copy of the database.
3. The database is not operational; it can stay in either read-only mode or no-recovery mode.
4. Transaction log for the “log-shipped” database is backed up on the primary server periodically. Note that only databases that are in FULL recovery mode can be log-shipped. Transaction log backups are placed on a shared drive; standby server’s SQL Server Agent account must have access to this shared drive.
5. Transaction log backups are copied to the standby server.
6. Transaction log backups are applied to the database on the standby server in the order that they were taken on the primary server.
7. Either primary server, standby server, or a separate server can be used to monitor log shipping. If you use a separate server for monitoring, it does NOT have to have Enterprise Edition of SQL Server; any edition (other than MSDE) will do.
© http://www.informit.com
