Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
SSRS Interview Question:
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
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.