Restore backup file with a diffrent name.

  • I have a backup file of a database. I would like to restore the backup file with a different name in Analysis server . How Could I do that ?.

    Thanks

    Thanu

  • I am not sure if you can do that. When you restore from the back up file , it would ask to overwrite the existing DB if  the db with same name exists.

    If there is any such way even I would like to know

     


    Regards,

    Meghana

  • Don't believe it can be done, unless you know how to edit your cab file and change the .inf and .rep files appropriately, as well as the taregt directory settings for the files contained within te cab.

     

    Steve.

  • on the source, right click on the database and select copy. then paste it back to the same server. enter the new name, then back it up and move it.

  • You forgot to mention reprocess in the middle of that sequence.  Copy and paste moves only the meta-data so the new DB will require a re-process prior to archiving off.

    Steve.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply