How to schedule SSAS Database backup.
Submitted by: AdministratorSQL Server Management Studio is used for taking backup of SQL Server Analysis Services database. SSAS backup option can not perform the SSAS database backup operation. To perform this task, create SQL Server Agent Job and schedule that job as per custom requirement. The following is the process:
► Right click the job folder of the SQL Agent node in SSMS.
► Select the option New job
► Specify the Job name for identification purpose.
► Go to Steps Page and click the New button.
► Select SQL Server Analysis Services command as the type of job after entering the name of the step and enter the server name.
► Enter the following command.
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>AdventureWorksDW</DatabaseID>
</Object>
<File>AdventureWorksDW.abf</File>
<AllowOverwrite>true</AllowOverwrite>
<Password>password</Password>
</Backup>
► Click on OK
► Goto the Schedule page for creating schedule as per the requirements.
Submitted by: Administrator
► Right click the job folder of the SQL Agent node in SSMS.
► Select the option New job
► Specify the Job name for identification purpose.
► Go to Steps Page and click the New button.
► Select SQL Server Analysis Services command as the type of job after entering the name of the step and enter the server name.
► Enter the following command.
<Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<DatabaseID>AdventureWorksDW</DatabaseID>
</Object>
<File>AdventureWorksDW.abf</File>
<AllowOverwrite>true</AllowOverwrite>
<Password>password</Password>
</Backup>
► Click on OK
► Goto the Schedule page for creating schedule as per the requirements.
Submitted by: Administrator
Read Online SSRS Job Interview Questions And Answers
Top SSRS Questions
☺ | Explain the architecture of reporting services? |
☺ | What is RAID (Redundant Array of Inexpensive disks)? Explain its level? |
☺ | What are the ways to tune Reporting Services? |
☺ | Describe Reporting Lifecycle? |
☺ | What can SQL Server Reporting Services do? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |