We use DDBoost to backup and restore our databases to a storage like SAN.
How can I integrate PowerShell with DDBoost to backup or restore a database.
Here it is a sample T-SQL command thru DDboost to refresh a dev database from production DB on different server:
EXEC @returnCode = dbo.emc_run_restore ’
-a NSR_DFA_SI_DD_HOST=pezdd01 (It is where our databases’ backups are stored like SAN)
-a NSR_DFA_SI_DD_USER=DDboost (this is ddboost user which has access to the backups)
-a NSR_DFA_SI_DEVICE_PATH=/SQLBoost_UGL (path of the storage)
-a “NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox”
-c ProdSERVER001 (Source (Prod DB) server )
-A DevSERVER001 (Target (Dev DB) server )
-C “’‘db_data’’=’‘I:\mssql\MSSQL12.MSSQLSERVER\MSSQL\DATA\TargetDB.mdf’’, ‘‘db_log’’=’‘J:\mssql\MSSQL12.MSSQLSERVER\MSSQL\Log\TargetDB_LOG.ldf’’”
-f -S normal -d MSSQL:TargetDB MSSQL:SOURCEDB’
Please let me know if need more clarification or detail.
Thanks and regards in advance.