SSAS database backup

• vigneshbeece

  Mr or Mrs. 500

  Points: 569

  More actions

  January 14, 2020 at 7:31 pm

  #3715377

  Hi All,

  I tried to backup SSAS databases(2008 R2) by using query in SSMS, but it is overwriting previous day backup.How to take backup without overwriting previous day backup. I need to maintain at least 7 days of backup. currently i scheduled job in SQL server agent which overwrites daily backup.

  Regards,

  Vignesh

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 15, 2020 at 8:10 pm

  #3715782

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  January 15, 2020 at 8:45 pm

  #3715788

  No idea at all how you are doing this. As a guess, If you use an XMLA script, you can make that dynamic and append a date stamp.You can find an example of using dynamic XMLA in this article:

  Dynamic XMLA using T-SQL for SQL Server Analysis Services

  In terms of overwriting, The default for the xmla script would be using <AllowOverwrite>true</AllowOverwrite>. You can change that to false but then you'd get an error if the file already exists, instead of the file being overwritten. I don't think that has anything to do with your issue, it's just an explanation of the overwrite.

  The scripts won't automatically just maintain 7 copies, you'd need to delete the older copies yourself.

  Sue