Restore Permissions

by Mar 26, 2014

I’m getting the following error when trying to restore to a different server (initiating log shipping). What security context do the xp’s run under?

xp_ss_restore did not complete. An error(0,1) was encountered. Please check the parameters and their values. [v7.2.1.26]

SQLsafeCmd output:
SQLsafe Backup and Recovery CLI Version (x64)
Copyright (c) 2004-2012 Idera, Inc., All Rights Reserved.

Connecting to Backup Agent on M0048688…success. (

Server instance: M0048688, Database: bainprod
User does not have permission to RESTORE database ‘bainprod’.
RESTORE DATABASE is terminating abnormally.

The SQLsafe Enterprise Backup Agent for the SQL server instance M0048688 has a trial license that will expire in 7 days on Wednesday, April 2, 2014.

— End of SQLsafeCmd output —

(0 row(s) affected)
Msg 50000, Level 16, State 1, Line 10
One or more operations failed to complete.