Sysadmin error when deleting log shipping configuration
I want to change the restoration delay time of the log shipping settings of my secondary databases from 15 minutes to one day. I clicked the “…” button on the “Transaction Log Shipping” properties, but there was an error during the execution of the Transact SQL statement, claiming that only the sysadmin members of the fixed server role are allowed to execute the operation (Microsoft SQL server, Error: 21089).
The SQL server is registered under SA in the SQL Management Studio, and the SQL login that has the sysadmin server role is connected to the secondary server when I set up the settings for log shipping for the secondary database. I unchecked the “Enable this as a primary database in a log shipping configuration,” but the log shipping configuration cannot be deleted and still gives the same error message about the sysadmin.