Solved

Delete DDB

  • 12 July 2022
  • 3 replies
  • 1684 views

Userlevel 1
Badge +3

Hello!

How I can just delete DDB when server with this DDB no longer exists? and these DDB are no longer needed.

 

Why do simple actions in Commvault cause “pain”?

icon

Best answer by Mike Struening RETIRED 13 July 2022, 19:44

View original

3 replies

Userlevel 7
Badge +23

@NikkyArt the DDB should age on its own once there are no jobs that reference the blocks within the DDB.

I covered the best way to find the jobs in another thread here:

Here’s the instructions:

If you have access to the SQL studio manager on the CS, below queries can be run to confirm if there are any jobs stuck in the DB for the DDB store.

use Commserv

select * from idxsidbstore

[this will list all stores, identify and make note of the store id for the one you are concerned with].

Next run the following query to list jobs associated to this DDB.

use Commserv

select * from archjobsonstoreinfo where storeid = n

[n = store id for the DDB in question]

If this query outputs any jobs, run a Data Retention Forecast and Compliance report on those copies to see why they are not aged.

If they don’t show up in the gui at ALL, then you will have to run qoperation per instructions in BoL link for qoperation agedata

https://documentation.commvault.com/commvault/v11_sp20/article?p=45239.htm

Now if that turns up empty, then we need to look at the SIDBPrune and SIDBPhysicalDelete log files on the Media Agents to see why data is not being removed.

Userlevel 1
Badge +3

@NVFD411 

  • Are jobs associated with the GDP’s
  • Are there any depended storage policies/storage pools?
  • Do the media agents that were assigned to the GDP still exist? 

 

no, no jobs for this GDP and others. I can not show/find delete button for DDB.

 

Userlevel 2
Badge +7

@NikkyArt - Please share some additional information with us.  

  • Are jobs associated with the GDP’s
  • Are there any depended storage policies/storage pools?
  • Do the media agents that were assigned to the GDP still exist? 

Please provide any errors or log snippets, that are issued when you attempt to deleted.

 

Reply