Log shipping Frequency

Question

Post reply

Log shipping Frequency

Bharat21

Right there with Babe

Points: 781
More actions
September 27, 2016 at 6:49 am

#321698

Is any one know what is the minimum log shipping frequency or time for SQL server 2014.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

andrew gothard SSChampion Points: 12301 More actions · Answer 1

Bharat21 (9/27/2016)
Is any one know what is the minimum log shipping frequency or time for SQL server 2014.

Via the wizard 10 seconds, but it would more likely be constrained by how long your log backups took

I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.

rvsc48 SSCertifiable Points: 7651 More actions · Answer 2

Hi, what is the problem you are trying to solve? The lowest I have ever seen in a production environment is every 5 minutes. Probably, the most common frequency setting is every 15 minutes (the default). Of course, at that low setting of every 5 minutes, you will have many transaction log backups, many copies, and many restores occurring. Also, the size of the transaction log backups which will be log-shipped should be smaller due to the increased frequency of the backup portion of the process.

Bharat21 Right there with Babe Points: 781 More actions · Answer 3

Thank you sir,

I have replicate data from one server to another, and my log shipping time is 1 hour, so whatever i have transferred data from one server to another it reflected to another server after one hour, so i have to reduce that time, so with in minimum frequency i have to reflect that data,

Is anymore suggestion for me?

rvsc48 SSCertifiable Points: 7651 More actions · Answer 4

I think Andrew would agree also, what is your RTO; Recovery Time Objective?

The recovery time objective (RTO) is the targeted duration of time and a service level within which a business process must be restored after a disaster (or disruption) in order to avoid unacceptable consequences associated with a break in business continuity.

How much time does the business give you to have the secondary database available and ready for connections from the application?

Grant Fritchey SSC Guru Points: 398679 More actions · Answer 5

Also, what is the Recovery Point Objective, the amount of data that the company is willing to lose during the log shipping operation. The answer is always zero, but zero is not attainable this way (or really, any other way with 100% assurance). 15 minutes? 5 minutes? That number also determines how often you should be shipping the logs.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Bharat21 Right there with Babe Points: 781 More actions · Answer 6

In our business we transfer data from one server to another i.e secondary with in one hour using log shipping, so ROT is one hour, so with in one hour whatever updated data comes we have transfer into another secondary server database to avoid disruption ,and also make easy to access in read only mode