Databases Reference
In-Depth Information
are appropriately passed back to Analysis Services for further evaluation of a
query.
Back-up and Restore
Backup is an operation that is part of every individual's life. If you have an im-
portant document you take a photocopy as a backup. Similarly, backup is an
extremely critical operation for any data warehouse. There are several reas-
ons why you should periodically back up your Analysis Services database.
One reason is for disaster recovery, another is for auditing purposes. Irre-
spective of purpose, it is always a good idea to back up your database on a
periodic basis. You can back up databases on your Analysis Services in-
stance through SSMS. Follow the steps below to backup the AnalysisServiec-
s2005Tutorial database.
1. Connect to Analysis Services instance using SSMS.
2. Navigate to the database AnalysisServices2005Tutorial in the Object
Explorer window.
3. Right-click the database and select Back Up
…
You will see the backup dialog shown in
Figure 12-18
.
By default the dialog
chooses the database name as the backup name. By default the backup file
will be created in the Backup folder your Analysis Services installation folder.
If you want the backup location on a different drive or directory, you first need
to change the Analysis Services server property AllowedBrowsingFolder by
adding the appropriate directory. You can then choose the folder by clicking
Browse in the Backup Database dialog and specifying a file name for backup.
You have the option to encrypt the database by specifying a password. You'll
need that password to restore the database. If you have remote partitions in
the database, you have the option of specifying the backup location for each
remote partition. Backup of these partitions is done on respective Analysis
Services instances on that machine.
1. Disable the option to encrypt the backup file.
2. Select the option to overwrite any existing backup files with the same
name.
Search WWH ::
Custom Search