SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform this Operation

(Pinal Dave) Even though there are many disaster recovery solutions available in SQL Server as of today, few of my clients Still go with log shipping. In this blog, I would share my learning about one of the errors which I observed with one of my clients.