I tried to backup SSAS databases (2008 R2) by using query in SSMS, but it is overwriting previous day's backup. How to take backup without overwriting previous backup. I need to maintain at least 7 days of backup. Currently I schedule a job in SQL Server Agent which overwrites daily backup.
This is the job step definition:
<Backup xmlns="schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>OLAP_Test</DatabaseID> </Object> <File>K:\OLAP Database Backups\SSAS\OLAP_test.abf</File> <AllowOverwrite>true</AllowOverwrite> </Backup>
IF I choose "Allow file overwrite option" to False , the job throwing the error
backup file already exists. Provide a different file name, delete the existing backup file, or set the AllowOverwrite setting to True, then repeat the operation.