January 14, 2020 at 7:31 pm
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
January 15, 2020 at 8:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 15, 2020 at 8:45 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply