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. ...

Ez a cikk a következő(k)re vonatkozik: Ez a cikk nem vonatkozik a következő(k)re: Ez a cikk nem kapcsolódik egyetlen konkrét termékhez sem. Ez a cikk nem azonosítja az összes termékverziót.
További források megtekintése

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. 
  1. Log in to SSMS with Administrator Privileges.
  2. 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.
  3. 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
 
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.
  1. 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
  1. 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
 
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.
  1. (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"

Érintett termékek

PowerProtect Data Manager, Microsoft App Agent
Termék tulajdonságai
Article Number: 000184234
Article Type: How To
Utoljára módosítva: 23 okt. 2025
Version:  7
Választ kaphat kérdéseire más Dell-felhasználóktól
Támogatási szolgáltatások
Ellenőrizze, hogy a készüléke rendelkezik-e támogatási szolgáltatással.