+8
Hey all -
I am working with a customer and we have the command line backup for a SQL instance working just fine using an xml file. What we can’t figure out is how do we do just 1 database on the instance? We see the api call in command center but it doesn’t translate to the xml. Anyone have the magic command? We tried adding <databaseName>xxxx</databaseName> right under instance in the xml.
Attached a sample of the xml.
Best answer by Gseibak
View original
+12
POST https://commserve/proxy/v2/sql/backup
{
"backupType": "FULL",
"instances": [
{
"sourceInstance": {
"instanceId": 28,
"instanceName": "SQL2\\PRODSQL2"
},
"selectedDatabases": [
{
"databaseId": 160,
"databaseName": "AppStudioDB"
}
]
}
]
}
+8
+12
I see the challenge. Let me dig a bit into this. Is there a reason to force XML or can you use JSON?
+8
He is calling command line from within SQL studio. I do understand how the APIs work, but how do we do that from within SSMS? The command line was pretty easy to get working using qoperation execute.
Hi Melissa,
try adding this section in the XML - you will need to replace the variables below with your config.
-<sqlDatabaseAssociation>
<databaseId>5</databaseId>
<databaseName>CommServ</databaseName>
-<associatedSubclient>
<subclientName>default</subclientName>
<backupsetName>defaultBackupSet</backupsetName>
<instanceName>CS1\COMMVAULT</instanceName>
<appName>SQL Server</appName>
<clientName>CS1</clientName>
<displayName>CS1LAB</displayName>
<commCellName>CS1LAB</commCellName>
<csGUID>21320A30-5383-4248-BF3D-AD1478A6C05F</csGUID>
</associatedSubclient>
you can also do a “save as” script from the subclient to generate the XML.
+8
Hope all is well!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
