类似GO指令? [英] Analogous to GO instruction?
问题描述
这是我在AS中的第一步。
我想在我的服务器上执行这两个数据库的备份实例。我有以下说明:
< Backup xmlns =" http://schemas.microsoft.com/analysisservices/2003/engine"> <对象> < DatabaseID> MyDatabaseID< / DatabaseID> < /对象> <文件> E:\OLAP\BACKUP\MyDatabaseID.abf< /文件>< /备份>
< Backup xmlns =" http://schemas.microsoft.com/analysisservices/2003/engine"> <对象> < DatabaseID> MyDatabaseID1< / DatabaseID> < /对象> <文件> E:\OLAP\BACKUP\MyDatabaseID1.abf< /文件>< /备份>
我收到此错误:
第14行第74行的'Backup'元素('http:/ /schemas.microsoft.com/analysisservices/2003/engine'名称空间)在Envelope / Body / Execute / Command下不止一次出现。
我在哪里做错了?我需要批次分隔符吗?如果我单独执行说明,它们将正常工作。
提前致谢。
H。
在这种情况下,您需要使用其他一些方法(如T-SQL)自动化XMLA, AMO等
参见
Hi,
This is my firsts steps into AS.
I want to execute the backup of these two Databases in my instances. I have the following intructions:
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>MyDatabaseID</DatabaseID> </Object> <File>E:\OLAP\BACKUP\MyDatabaseID.abf</File></Backup> <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>MyDatabaseID1</DatabaseID> </Object> <File>E:\OLAP\BACKUP\MyDatabaseID1.abf</File></Backup>
I obtain this error:
The 'Backup' element at line 14, column 74 ('http://schemas.microsoft.com/analysisservices/2003/engine' namespace) appears more than once under Envelope/Body/Execute/Command.
Where am I doing wrong? Do I need a batch separator? If I execute the instructions separately they will work properly.
Thanks in advance.
H.
you need to automate XMLA in that case using some other methods like T-SQL, AMO etc
see
这篇关于类似GO指令?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!