Backup-ASDatabase
Enables a database administrator to take the backup of Analysis Service Database to a file.
Backup-ASDatabase [-BackupFile*] <string> [-Name*] <string> [-AllowOverwrite <SwitchParameter>][-BackupRemotePartitions <SwitchParameter>] [-ApplyCompression <SwitchParameter>] [-FilePassword <SecureString>][-Locations <Microsoft.AnalysisServices.BackupLocation[]>] [-Server <string>] [-Credentials <PSCredential>][<CommonParameters>]
Backup-ASDatabase -Database* <Microsoft.AnalysisServices.Database> [-AllowOverwrite <SwitchParameter>][-BackupRemotePartitions <SwitchParameter>] [-ApplyCompression <SwitchParameter>] [-FilePassword <SecureString>][-Locations <Microsoft.AnalysisServices.BackupLocation[]>] [-Server <string>] [-Credentials <PSCredential>][<CommonParameters>]
Enables a database administrator to take the backup of Analysis Service Database to a file. If only backup file name is mentioned without the location, the default backup location specified during the installation will be considered. Database Administrator can also pass multiple databases through pipeline and perform the backup operation.
Parameters |
---|
-BackupFile <string>
|
-Name <string>
|
-AllowOverwrite <SwitchParameter>
|
-BackupRemotePartitions <SwitchParameter>
|
-ApplyCompression <SwitchParameter>
|
-FilePassword <SecureString>
|
-Server <string>
|
-Credentials <PSCredential>
|
-Locations <Microsoft.AnalysisServices.BackupLocation[]>
|
-Database <Microsoft.AnalysisServices.Database[]>
|
<CommonParameters>
|
Inputs
Microsoft.AnalysisServices.Database
Examples
- Backup the database ‘mydatabase’ to a file ‘mydb.abf’:
C:PS> Backup-ASDatabase mydb.abf mydatabase
The backup file will be available at the default backup location specified during Analysis Service installation.
- Backup the database ‘mydatabase’ to a file ‘mydb.abf’ at the location ‘D:MyFolder’ and compresses the backup file:
C:PS> Backup-ASDatabase "D:MyFoldermydb.abf" mydatabase -AllowCompression
- Backup the database ‘mydatabase’ to a file ‘mydb.abf’ at the location ‘D:MyFolder’:
C:PS> Backup-ASDatabase "D:MyFoldermydb.abf" mydatabase -AllowCompression -FilePassword:$pwd
This compresses and encrypts the backup file.