A
A
Azure Stack Hub Multi Stamp Management
Cloud Assert Home
Docs Home
Search…
2201.1
Introduction
Release Notes
Key Concepts
ADMIN
INSTALLATION
Prerequisites
Deployment
Configuration
Others
Troubleshooting
Configure VConnect PowerShell Modules
Stamp Connectivity
Stamp Syncing
Enable MSM VConnect Scheduled Tasks
Add Billing API Port To VConnect RP Network Security Group
Add Transaction Log Shrink Job in SQL Server
Powered By
GitBook
Add Transaction Log Shrink Job in SQL Server
PowerShell command to create/update Shrink Log Job
The following step will help to add a job in SQL Server Agent to shrink the transaction log size in the Database of VConnect, Billing, Hybr and DACM.
Open a PowerShell window in the SQL Server machine in elevated mode.
Click
here
for the steps to install / update the CloudAssert.Common PowerShell module.
Click
here
for the steps to add a SQL Database Connection.
Execute the following command to add Transaction Log Shrink Job.
Add-SqlTransactionLogShrinkJob
Input
Description
SQL Connection Name
Name of the SQL database connection created earlier. Ex:
vconnect-sql
Backup folder path
The path for saving the database backup and log backup. Ex: C:\\Backup
No.of days to purge old backup
The number of days to retain the backup
Hybr Database Name, VConnect Database Name, Billing Database Name, DACM Database Name
Enter 'Y' if it uses the mentioned DB name. Enter 'N' and specify if a different DB name is used.
​
Previous
Add Billing API Port To VConnect RP Network Security Group
Last modified
4mo ago
Copy link