version the SSAS Backup

• pat-261672

  Hall of Fame

  Points: 3325

  More actions

  April 17, 2008 at 6:59 am

  #379985

  Hi all,

  how can i do version back up of SSAS cube backup because i only does one day back up at a time and i want to keep 2 days of worth backup on the process!!

  so if i the back up has done last night i need to name it as cub04162008.abf and todays backup would be cube04172008.abf!!

  please help!!

  Thanks

  Pat

• Mohan Kumar

  SSCertifiable

  Points: 5365

  More actions

  April 19, 2008 at 7:28 pm

  #804678

  (Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine")

  (Object)

  (DatabaseID)POM(/DatabaseID)

  (/Object)

  (File)C:\PO.abf(/File)

  (/Backup)

  Above query will help you in doing it. You need to replace ( with Angular Bracket and ) with closing Angular Bracket

  P.S. I could not write proper query as Angular bracket is being considered as HTML tag 🙁

  [font="Verdana"]--www.sqlvillage.com[/size][/font]