Forum Discussion

杰克逊1300's avatar
杰克逊1300
Copper Contributor
Jun 08, 2023

HOW TO DYNAMICALLY BACK UP SSAS TABULAR DATABASE FOR THE LAST 7 DAYS DAILY WITH POWERSHELL

Daily backup ssas tabular database, dynamic backup for the last 7 days. powershell or other way can do it? this is a sample by powershell, but it not work. can you help me? thanks a lot. powershe...
Analysis Services
olafhelper's avatar
olafhelper
Bronze Contributor
Jun 08, 2023
What do you mean with "for the last 7 days"?
  • 杰克逊1300's avatar
    杰克逊1300
    Copper Contributor
    Jun 09, 2023
    IT means recent 7 days. for example, toady is 20230609, I will backup recent 7 days ssas tabular database for 20230602, 20230603, 20230604, 20230605, 20230606, 20230607, 20230608. tomorrow 20230610, I will backup 20230609, and dynamicly delete 20230602, only preserve recent 7 days daily ssas backup.
    • olafhelper's avatar
      olafhelper
      Bronze Contributor
      Jun 09, 2023
      Sorry, your post is still more then unclear.
      You can backup a SSAS as it is right now, you cannot backup a database/data state somewhere in the past.

Resources