1

Following the link Link I tried to verify ssas backup and executed below mentioned command in specified path as in link.

msmdsrv -j -b "\\path\ssasfile.abf"

But all it outputs is the arguments I passed in:

 -j -b \\path\ssasfile.abf

However, I was expecting output as mentioned in the post How to check the health of a SSAS database? And of its backups?. Any suggestion is much appreciated.

Glorfindel
  • 2,205
  • 5
  • 19
  • 26
Pramod Maharjan
  • 11
  • 2

1 Answers1

2

That's what happens when you pass in a backup file that either doesn't exist or on which you don't have access.

For example if I run the command on an existing backup file I get this:

msmdsrv -j -b "c:\temp\AdventureWorksDW2012Multidimensional-EE.abf"

Outputs the arguments as well as the test results:

-j -b c:\temp\AdventureWorksDW2012Multidimensional-EE.abf

Backup file \?\c:\temp\AdventureWorksDW2012Multidimensional-EE.abf contains database with the Name of AdventureWorksDW2012Multidimensional-EE and Id of AdventureWorksDW2012Multidimensional-EE consisting of 7927 files with the total size of 5554858464 bytes All files were successfully tested

You can see the output starts with the arguments and then shows the test results.

If you point msmdsrv.exe to a non existing backup file it just returns the arguments and no results (unfortunately no error message either)

msmdsrv -j -b "c:\temp\NOTEXISTING.abf"

simply returns

-j -b c:\temp\NOTEXISTING.abf

Tom V
  • 15,752
  • 7
  • 66
  • 87