Databases Reference
In-Depth Information
can launch the backup dialog from each database you want to backup and
run backups in parallel. Alternatively, you can create a DDL that will execute
backup of multiple databases within the same command.
Whenever you want to restore an Analysis Services database for which you
have a backup, you can do so by using the restore dialog. To a restore a
database on an Analysis Services instance launch the restore dialog by right-
clicking the Database folder from Object Explorer of SSMS and select
Figure 12-19
Specify the database you want to restore and the backup file for that data-
base. If the database already exists and you want to overwrite the existing
database object, you can do so by clicking the option Allow Database Over-
write. You can restore the entire database including security information or
you can skip the security defined on the backup file during restore. If you had
provided a password during backup of this database, you need to specify the
same password for restore operation. Once the database has been restored
you can query the database. You can take a backup of a database from your
test servers and restore it on production server. In such a circumstance you
might choose to skip the security information if the security defined on pro-
Search WWH ::
Custom Search