January 20, 2010 at 6:21 am
hi
i have .abf file how do i restore it please help
January 20, 2010 at 1:09 pm
You can easily script the BACKUP or RESTORE statement from a Backup Database/Restore Database dialog. Analysis Services 2005 even allows you to encrypt and compress backup files. Both backup and restore statements are implemented through XML for Analysis (XMLA) and look similar to the following:
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>test</DatabaseID>
</Object>
<File>c:\test.abf</File>
<ApplyCompression>false</ApplyCompression>
</Backup>
<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<File>c:\test.abf</File>
<DatabaseName>NewTest</DatabaseName>
</Restore>
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply