SQL log shipping allows to backup the transaction logs from primary SQL Server instance in regular interval to one or multiple secondary SQL Server instance. Transaction log backup are restored to all the Secondary SQL Server instances individually.
SQL Log Shipping consist of 3 operations:
•Backup transaction log from the primary server
Above 3 operation will create 3 jobs on SQL Servers. Backup Job will be only available on Primary SQL Server instance. However, Secondary SQL Server instance contains the Copy job and Restore job. All these job executes in regular interval and you can define the time. SQL agent service has to be on running for log shipping.
•Log Shipping Advantages:
SQL Log Shipping consist of 3 operations:
•Backup transaction log from the primary server
•Copy the transaction log backup to the secondary server or secondary servers
•Restore the transaction log backup to the secondary server instance
•Log Shipping Advantages:
Flexibility to backup, copy and restore the transaction logs.
- Due to scheduled jobs database corruption can be avoided.
- Multiple secondary databases can be configured
- Secondary databases are in read-only and standby mode and can queried if required.
- Log shipping allows multiple standby databases
•Log Shipping Disadvantages:
- No option for automatic failover
- Minimum time to synchronize is a min. which can be configured.
- For failover need to execute SQL Query. not simple as database mirroring.
Note:- Transaction Log Shipping can be configured for the databases having Full Recovery Model. It can not be configured
No comments:
Post a Comment