When it comes to Disaster Recovery Setup, every DBA has its own preference. I personally prefer Log Shipping since it involves very little effort to setup. Log shipping has many benefits as stated below:-
- Multiple Secondary copies with different delay and uses
- Can be used as Disaster Recovery Technique
- Can be used for Limited Reporting Workload
- Can be used to migrate data to a new location with minimum downtime
- SQL Server Upgrade
- No additional load on Primary instance
- Works well in combination with other HADR features like Mirroring, AlwaysOn, Clustering etc.
But If you use Domain Account for SQL Services, then Log Shipping using Custom scripts could be established in much easier way than the default log shipping method. For this purpose, I have created by own Log Shipping procedure [dbo].[usp_DBAApplyTLogs]
Latest Code of [usp_DBAApplyTLogs]
To learn on how to use this script, please watch below YouTube video:-
