PowerProtect Data Manager Microsoft agent: Upgrading T-SQL stored procedures in a user database
Summary: By default, the installation wizard (CLR deployment wizard) creates the stored procedures in the master database. However, it is possible to create and register the T-SQL stored procedures in a user database, which is not a master database. ...
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Instructions
Note: This procedure uses the default Microsoft application agent installation path. If the Microsoft application agent is not installed in the default path, use the relevant path in the commands.
Note: When upgrading Microsoft application agent, do not deploy the CLR Assembly on the SQL Server instance, on which you want to register the Microsoft application agent stored procedures in a user database.
The following steps apply if the assembly is already registered on the instance.
Note: When upgrading Microsoft application agent, do not deploy the CLR Assembly on the SQL Server instance, on which you want to register the Microsoft application agent stored procedures in a user database.
The following steps apply if the assembly is already registered on the instance.
- Log in to SSMS with Administrator Privileges.
- Go to the drive in which the Microsoft app agent is installed by default. This is C:\Program Files/DPSAPPS/MSAPPAGENT/bin. Find the executable named ddbmaSQLCLRDeployApp.exe and run it as administrator.
- After the Microsoft application agent installation completes, run the following commands on the SQL Server: sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO sp_configure 'clr enabled', 1;
GO RECONFIGURE;
GO
RECONFIGURE;
GO sp_configure 'clr enabled', 1;
GO RECONFIGURE;
GO
Note: If you have modified the CPU or I/O affinity mask for the server, replace RECONFIGURE with RECONFIGURE WITH OVERRIDE in the above commands. This modification disables configuration parameter checking that otherwise prevents the changes from being made.
- Create a log in the master table by running the following commands:
create asymmetric key ddbmaCLRExtensionKey from executable file ='C:\ProgramFiles\DPSAPPS\MSAPPAGENT\bin\DDBMASQLCLRLib.dll'
go
create login ddbmaCLRExtLogin from asymmetric key ddbmaCLRExtensionKey; go grant unsafe assembly to ddbmaCLRExtLogin;
go
go
create login ddbmaCLRExtLogin from asymmetric key ddbmaCLRExtensionKey; go grant unsafe assembly to ddbmaCLRExtLogin;
go
- Run the following commands on the user database in which you want to register or save the stored procedures:
CREATE ASSEMBLY ddbmaSQLCLR from 'C:\Program Files\DPSAPPS\MSAPPAGENT\bin \DDBMASQLCLRLib.dll' WITH PERMISSION_SET = UNSAFE;
go CREATE PROCEDURE emc_run_backup @cmdText nvarchar(MAX) AS EXTERNAL NAME ddbmaSQLCLR. [ddbmaSQLCLRLib.DDBMASQL].RunBackup;
go
CREATE PROCEDURE emc_run_restore @cmdText nvarchar(MAX) AS EXTERNAL NAME ddbmaSQLCLR. [ddbmaSQLCLRLib.DDBMASQL].RunRestore;
go
CREATE PROCEDURE emc_run_delete @cmdText nvarchar(MAX) AS EXTERNAL NAME ddbmaSQLCLR. [ddbmaSQLCLRLib.DDBMASQL].RunDelete;
go
go CREATE PROCEDURE emc_run_backup @cmdText nvarchar(MAX) AS EXTERNAL NAME ddbmaSQLCLR. [ddbmaSQLCLRLib.DDBMASQL].RunBackup;
go
CREATE PROCEDURE emc_run_restore @cmdText nvarchar(MAX) AS EXTERNAL NAME ddbmaSQLCLR. [ddbmaSQLCLRLib.DDBMASQL].RunRestore;
go
CREATE PROCEDURE emc_run_delete @cmdText nvarchar(MAX) AS EXTERNAL NAME ddbmaSQLCLR. [ddbmaSQLCLRLib.DDBMASQL].RunDelete;
go
After you register or save the stored procedures in a user database, you must use this user database to run T-SQL procedures to perform backups and restores.
- (Optional) Run backup using T-SQL to test a small backup.
Additional Information
Refer to page 16 of the "PowerProtect Microsoft Application Agent Installation Guide Version 19.5"
Affected Products
PowerProtect Data Manager, Microsoft App AgentArticle Properties
Article Number: 000184234
Article Type: How To
Last Modified: 23 Oct 2025
Version: 7
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.