Re: Backup and restore question

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dave is talking about Analysis Services 2005. 

If you are referring to the 2000 version then archiving and restoring 
the database from one server to the other should work fine as long as 
the 2 servers are in the same domain.

Right click on the database in Analysis Manager on the source server and 
choose the "Archive Database..." option. Then right click on the server 
node on the destination server and choose "Restore Database..."

If you are talking about a disaster recover scenario then there are 2 
items that need to be restored.

1. All the files in the data folder, by default this is stored at:
   C:\Program Files\Microsoft Analysis Services
   but this location can be configured from Analysis Manager.


2. The repository. By default, this is located in a file called:
   C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb

   But it can also be stored in a SQL database if you chose the option    
   to migrate your repository (or if you are running a 64bit edition)
   In the case of the SQL based repository, the standard operations for 
   backing up and restoring a SQL Database apply.

HTH

-- 
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <F36AB34D-AD86-454F-9132-108040760A13@xxxxxxxxxxxxx>, 
burt_king@xxxxxxxxx says...
> Mine didn't even come up with a "How to....."
> 
> 
> 
.

Relevant Pages

  • Re: sbs2003 and sharepoint
    ... The process described in the link does not refer to restoring to a different server. ... Your first step would be to have a new companyweb on an SBS server and then restore to that the files in from the databases you backed up. ... >> database the other one is the configuration database. ...
    (microsoft.public.windows.server.sbs)
  • Re: How do you plan to archive old SharePoint data?
    ... SharePoint Portal Server MVP ... > SharePoint's lack of long term archiving capabilities. ... > database becomes several hundred gigabytes in size or larger??? ...
    (microsoft.public.sharepoint.portalserver)
  • SQLDMO: howto obtain logical file names from a BAK file
    ... what, how, when does a logical file name is determine for a database? ... If I am restoring a db from Enterprise Manager, under the Options tab, ... the actual BAK file, but I haven't figured that out yet. ... file comes from another SQL server, was created in another folder, so ...
    (microsoft.public.sqlserver.programming)
  • Re: Restore Content Database problem
    ... I found that by having the exact same security as I did before hand ... The new server was not put onto a domain but once it ... I have spent basically the whole day reading about restoring the ... content database in WSS but I still can't seem to get it working. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Restore SharePoint Server backup to New Server
    ... But here the problem is after restoring the database I am ... and configure SharePoint on the new server it will create a new config DB. ... I am having a problem while restoring the backup from old server to a new ...
    (microsoft.public.sharepoint.portalserver)