Hi Team,
Is it possible to configure where the offline / decommissioned Database from SQL server will be removed from the Subclient ?
Solved
Automatically removing the offline / decommissioned DB from Subclient
Best answer by Scott Reynolds
If they take the database offline it's not removed from the content however that status of the database is checked at the beginning of the job during discovery. Any offline databases will be skipped on the backup. It will be noted the database was offline and skipped in the status tab of the job. It will still complete the other DBs normally.
- Vaulter
- 482 replies
Hello
I believe you are talking about a database that has been removed from the SQL server itself, correct? In that case when the database no longer exists on next backup when the discovery detects it's been deleted that database is removed from the subclient content.
This is the default behavior. You can choose to have the deleted DBs NOT be removed from the content tab by leveraging an additional setting:
It can be set per client/group or at the control panel to affect the entire CommCell as per link above.
Scott Reynolds wrote:
Hello
I believe you are talking about a database that has been removed from the SQL server itself, correct? In that case when the database no longer exists on next backup when the discovery detects it's been deleted that database is removed from the subclient content.
This is the default behavior. You can choose to have the deleted DBs NOT be removed from the content tab by leveraging an additional setting:
It can be set per client/group or at the control panel to affect the entire CommCell as per link above.
Thanks Scott, yes you are correct but what if the SQL team offline an database, will commvault remove from sub client automatically when backup runs ?
+17- Commvault Certified Expert
- 638 replies
Hi
If a database is configured within a subclient content and the SQL admin removes the database on SQL level then the subclient will still exist.
Depending on the content definition (detect DB vs static content) it will keep the config or adjust it accordingly.
- Vaulter
- 482 replies
- Answer
If they take the database offline it's not removed from the content however that status of the database is checked at the beginning of the job during discovery. Any offline databases will be skipped on the backup. It will be noted the database was offline and skipped in the status tab of the job. It will still complete the other DBs normally.
Scott Reynolds wrote:
If they take the database offline it's not removed from the content however that status of the database is checked at the beginning of the job during discovery. Any offline databases will be skipped on the backup. It will be noted the database was offline and skipped in the status tab of the job. It will still complete the other DBs normally.
Thanks Scott for your information !
Jos Meijer wrote:
Hi
If a database is configured within a subclient content and the SQL admin removes the database on SQL level then the subclient will still exist.
Depending on the content definition (detect DB vs static content) it will keep the config or adjust it accordingly.
Thanks Jos!
+2Hello,
I have an additional question for this thread:
What other db operations except:
- deletion,
- attache / detache,
can removed db from the Subclient contents?
+23- Vaulter
- 4996 replies
/none that I am aware of
Are you seeing anything like this occurring, or just curious?
+2Mike Struening wrote:
/none that I am aware of
Are you seeing anything like this occurring, or just curious?
Hello Mike, the customer just wants to have full knowledge.
+23- Vaulter
- 4996 replies
Are you looking for a REST API call to do this?
We have a ton of stuff available at http://api.commvault.com
Let me know if that’s the type of operation you seek.
Thanks!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.