Skip to Content
author's profile photo Former Member
Former Member

SAP BPC 7 APPSet Restore SQL 2005

Hi Everyone,

I have SAP BPC 7 setup in a multi-server environment, and it's working well. I created a dev environment, installed SAP in the same fashion, and now when I try to restore an app set through server manager in dev, it keeps putting the SQL DB on C instead of where it should go on I:\ .

The original app set was using this same drive configuration, and that backup/restore works fine -

I've gotten this to work before, but I can't seem to get the restore to go somewhere else this time...

Any thoughts appreciated -

Edward

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Apr 07, 2010 at 03:54 PM

    HI,

    You have to check the SQL database settings, there there is speified the place for data files and log files. I think you have C drive there. The Server Manager is doing a simple restore form bak and it is using the settings from SQL Server.

    Hope this can help you,

    Mihaela

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 07, 2010 at 04:01 PM

    Hi Edward,

    did you designate that data path (i:) during the installation of SQL server or did you change it after SQL was installed? I have seen instances where the registry keeps the path that was chosen during the installation of SQL, regardless of what is configured after the installation, and BPC was using that path during the appset restore process.

    best regards,

    Bruno

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2010 at 04:16 PM

    I tried that first, both changing the SQL server properties via the GUI for DATA and LOGS, and making sure the Reg entries pointed to the right location - i'll try another reboot in-case I was not thinking clearly 😊

    Add a comment
    10|10000 characters needed characters exceeded

    • yes that seem to be consistent with my observations in past versions. I think I had been able to change some info in the registry to change that path. However i don't remember what the key is.

      (Edward, Keep in mind that changing the registry is not without risks...)

      so.. in my opinion... 2 courses of action:

      - finding the registry setting and changing it, and testing to verify that it resolved the issue.

      - or reinstalling everything including SQL with the proper paths during installation of SQL.

      (uninstalling BPC server, uninstalling SQL server, reinstalling SQL server and reinstalling BPC server)

      Best regards

      Bruno

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2010 at 09:16 PM

    Thanks Sebastian,

    This is the third time I have ran into this issue, from 5.0 - 7.0, and I agree with your findings, but in the past I have been able to modify the registry keys for DataDefault, and LogDefault to point to the (I and L drives in this case) alternate drive, but in this scenario, that is not working.

    In the appset that was backed up, and hence trying to be restored here, the drives are laid out the same, C, I, L so if the app set was backed up in this drive scenario, it should be able to be restored..I thought 😊

    Right now, since this is an attempt to build a dev env copy of a prod env, I expanded the C: drive on the SQL server, and restored the app set. It's hung up at the OLAP db portion for some odd reason, but my plan was to once it was in - change it to the I drive by moving the db through detach/re-attach, since SAP shouldn't really care at that level (all pure assumptions).

    I awarded partial points for such diligent testing though - much appreciated -

    I'll follow up tom-

    TIA _

    Edward

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 07, 2010 at 09:19 PM

    To what Bruno mentioned, I have to say that having this (since it's the dev version of our prod) in a virtual environment has made this possible to test. I can snapshot before any 'attempt' etc, and recover back in mere seconds - in testing several other hairy SAP buggies in our environment, this has been even more useful-

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      i faced a similar issues, there is a OSS note for this. 1449815. It talks about restore the appset manually, but it does not say how, it asks to open a OSS message but i am sure that will take days. Any suggestions.

      regards

      Yogesh

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.