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 GseibakView original
I see the challenge. Let me dig a bit into this. Is there a reason to force XML or can you use JSON?
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.
try adding this section in the XML - you will need to replace the variables below with your config.
you can also do a “save as” script from the subclient to generate the XML.
Hope all is well!