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. [v18.104.22.168]
SQLsafe Backup and Recovery CLI Version 22.214.171.124 (x64)
Copyright (c) 2004-2012 Idera, Inc., All Rights Reserved.
Connecting to Backup Agent on M0048688…success. (126.96.36.199)
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.