Announcement Banner
UNSOLVED

nrgreen

updated

9 years ago

N

nrgreen

21 Posts

0

1714

April 11th, 2017 06:00

msagent - unable to list backups

When trying to use the command

msagentadmin -s --ddhost ddcdmp01.lyondell.com --ddpath /data/col1/DDCT2SQL --dduser ddboost --client edcdbd85.lyondell.com

we will get the following error

Error occurred while reading the lockbox 'C:\Program Files\DPSAPPS\common\lockbox': Failed to retrieve the password from the lockbox.

Can someone please help me figure out why i am getting this error

  • nrgreen

    21 Posts

    1281

    0

    Posted April 11th, 2017 08:00

    I was able to get past that by running CMD as administrator  but the output is as follows

    For client 'edcdbd85.lyondell.com":latest save set it, taken 12/31/1969 6:00:00 PM

    Listed 0 Backups.

    Not sure why it would list that and not all the existing backups on the DD system

  • bpettus

    1 Message

    1281

    0

    Posted September 18th, 2018 11:00

    This is an old post but relevant to my problem.  I'm getting a similar message as nrgreen.  How does one get a list of backups for a particular DDBoost for SQL client?

    I'm trying to automate the process of restoring SQL Server backups (both full and transaction logs) to another server.  To do so, I need to query the DD for available backups and initiate the restore.  I know the CLI to initiate the restore.  I don't know how to enumerate the list of backups.  The msagentadmin.exe utility tells me there are no backups.  I know there are backups because the DDBoost GUI lists a set of available backups.  Is the msagentadmin.exe the correct utility?  Where is the CLI reference (had a bugger of a time finding useful documentation)?

    Tanks.