Cube back up

  • hi

    i have .abf file how do i restore it please help

  • 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