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 7.2.1.26 (x64)
Copyright (c) 2004-2012 Idera, Inc., All Rights Reserved.
<http://www.idera.com/>

Connecting to Backup Agent on M0048688…success. (7.2.1.26)

RESTORE bainprod…FAILED.
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.