Sample Header Ad - 728x90

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

2 votes
2 answers
2850 views
I am an administrator in SSAS . I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine . I successfully backup the SSAS databases and even check if the backups are healthy Recently, however, one of our servers which is managed by a third party company based in Canada, needed to be replaced, and while migrating all the ssas databases from the old server to the new one this is the old server: enter image description here this is the new server: enter image description here I am getting this error message while processing the database in the new server: > This command cannot be executed on database 'DWCA' because it has been > defined with StorageEngineUsed set to TabularMetadata. For databases > in this mode, you must use Tabular APIs to administer the database. enter image description here
Asked by Marcello Miorelli (17274 rep)
Sep 20, 2019, 12:25 PM
Last activity: Jan 3, 2022, 02:00 PM