MS SQL 2005 Shipping Log sysadmin role

roma_vt used Ask the Experts™
I use MS SQL 2005
Security requirements - all jobs (steps inside jobs) are running with using special SQLProxyAccount.

This account have no sysadmin role granted.

LogShipping job failing with next errors:

Could not retrieve backup settings for primary ID
The specified login is not a member of the sysadmin fixed server role for server

How can I run Log Shipping without using sysadmin fixed role?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Software Analyst
From here I found the following comments:

Before using the Database Maintenance Plan Wizard, consider the following:

The user configuring log shipping must be a member of the sysadmin server role in order to have permission to modify the database to log ship.

You can configure log shipping only on one database at a time. If you select more than one database, the log shipping option on the wizard is disabled.

The login used to start the MSSQLServer and SQLServerAgent services must have access to the log shipping plan jobs, the source server, and the destination server.

When you use the Database Maintenance Plan Wizard to configure log shipping, you can log ship only to disks. The backup-to-tape option is not available.

So the answer to your question is, there is no way to run Log Shipping without using the sysadmin fixed role.


Thanks, cpkilekofp
Christopher KileSenior Software Analyst

You're welcome, roma_vt :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial