May 9, 2017 at 8:32 am
Hello,
SQL Server 2016 SP1 EE, on Windows Server 2012 R2 Standard, as I Dev on a Prod tab cube all on same instance, I make a backup first. Also make another named backup for users to work from a static copy till I push dev changes over the prod cube. I now have a lot of .abf files in the backup folders. What is the best way to clean out all these old .abf files, just use Explorer and delete? What about folders made by system from the static backup cubes I had on the instance, folder gets created and regular backups are taken, those aren't needed either. Whack them with Explorer and click delete as well? I ask, I'm concerned about interfering with the systems cataloging the backups, can't find any other way to delete.
Thanks,
JQ
May 18, 2017 at 12:25 pm
I'd say whack the files you don't want in explorer. Take a look at this: http://www.ssas-info.com/analysis-services-scripts/2679-script-to-backup-ssas-database-and-delete-old-backup-files to see if that provides any help.
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply