Resolution #1:
Delete from GUI - Repository
Resolution #2:
vRanger version 7.5.1 added the ability to search, filter and delete savepoints from all repositories excluding replication repositories.
With this change, a new Remove Savepoints option is presented on the repository right-click menu to Remove Savepoints.
Notes:
- If the selected repository has a replication repository configured. The corresponding savepoint in the replication repository is also deleted.
- As part of this enhancement, you can no longer delete savepoints from a replication repository directly.
Resolution #3:
If the number of savepoints is too large to do manually, we can run this Powershell script to automate the activity.
Requirements:
- PowerShell ver. 2 or greater.
- Credentials of vRanger user on Services and Database (by default they are the same)
- BETReposync03.2.ps1 script provided by vRanger Support.
Collect the following information:
- SQL Instance name: In the GUI | Tools | Options | General | Database | Database Server
- vRanger Database name: By default it is vRangerPro, can be checked with SQL Management Studio.
- Authentication for vRanger to the SQL database, by default it is vRanger's user. Recommended to Log In the server with vRanger's user (as seen on Services | Log On As)
- Name of your Repository as seen on the GUI | My Repositories
- Credentials to your Repository. Right Click your Repository | Edit | Review Username.
Steps:
- First let's make sure you are not running any Jobs
- let's proceed to Services and then Stop vRanger services. We usually stop them from Top to Bottom.
- Extract Reposync from archive.
- Launch PowerShell console as Administrator
- Allow script execution if necessary: Set-ExecutionPolicy unrestricted
- Change directory to the script location, e.g. c:\BETreposync.
- Execute script: .\reposync03.2.ps1
- On the opening menu, enter the SQL Instance name.
- Enter vRanger database.
- Enter Authentication
- Enter the number assigned to your Repository of interest.
- Enter Credentials to your repository.
- On the following menu select number '3' to Expire old SPs
- Enter Threshold date in yyyyMMdd format to expire savepoints prior to that date.
- The Script will run and start deleting the expired savepoints.
- When finished, Exit the Script and Start the vRanger Services (usually from Bottom to Top).