Unsolved

590

January 10th, 2022 08:00

Microsoft App Agent - flat file restore without SQL Server

I have two servers: server-1 is a SQL Server storing database backups into data domain using Data Domain Boost Microsoft App Agent, currently latest version 19.8. I would like to restore these database backups as files on different server, server-2, which serves as backup server and does not have SQL Server installed, only the Microsoft App Agent.

Using the msagentadmin administration cmd commands I'm able to list the required database backups:

Client = server-1.domain.com, date and time = 1/9/2022 2:30:31 AM (1641691831), size = 2572, name = SQL_Backup_FULL:Monitoring.

but I'm not able to restore them using the ddbmsqlrc command, due to following error:

Version information for C:\Program Files\DPSAPPS\MSAPPAGENT\bin\ddbmsqlrc.exe: Original file name: ddbmsqlrc.exe Version: 19.8.0.0.Build.28 Comments: A Dell EMC product that allows backup and recovery of Microsoft applications

52701:ddbmsqlrc: Command line:
C:\Program Files\DPSAPPS\MSAPPAGENT\bin\ddbmsqlrc.exe -q -a NSR_DFA_SI_DD_HOST=mydatadomain.domain.com -a NSR_DFA_SI_DD_USER=sql_user -a NSR_DFA_SI_DEVICE_PATH=/sql_user -a NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox -c server-1.domain.c
om -t 1/9/2022 2:30:31 AM -a FLAT_FILE_RECOVERY=TRUE -a FLAT_FILE_RECOVERY_DIR=K:\RestoredDatabases MSSQL:Monitoring

Unable to connect to SQL Server instance 'SERVER-2'. Ensure that the SQL Server instance is running and the SQL login permissions are correct.

I've tried experimenting with msagentrc but this one looks to work only with Storage Direct backups and not my Application Direct ones:

msagentadmin list --ddhost "mydatadomain.domain.com" --ddpath /sql_user --dduser sql_user --client server-1.domain.com
For client 'server-1.domain.com': latest save set is , taken 1/1/1970 1:00:00 AM.
Listed 0 backups.


Does anyone knows if it's possible to restore flat file backups without SQL Server running on server?
As a workaround I'm restoring the database files on server-1 with \\SERVER-2\RestoredDatabases fileshare path, but I would like to remove this dependency.

Thanks in advance.

No Responses!
No Events found!

Top