Sysadmin error when deleting log shipping configuration

Asked By Stanley Aaron 0 points N/A Posted on - 11/03/2011

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.

• Status: Open
• Question Views: 3799
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Mahesh Babu 20 points N/A #105087

Sysadmin error when deleting log shipping configuration

Hallo Stanley Aaron,

I will advise that you check keenly and ensure that you have set the owner of the database as the system administrator, who should be having the full capability to perform that role, because if you are accessing the database a user with limited capabilities when it comes to editing and making changes to the database then it's possible that you will not be able to do that hence the error that you are getting. Also check to ensure that if you are using the system admin account it has all the privileges for editing and making changes.

Otherwise, you might want to report that as a bug to the SQL support.

__

Regards
Mahesh Babu

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/22/2011
• Question Category: Misc Software