How do I delete an Azure Analysis Services tabular model that is in an inconsistent state and cannot be accessed

rhei78 0

I have an Azure Analysis Services tabular model that is currently in an inconsistent state and cannot be accessed. If I try to delete it using SQL Server Management Studio, it shows the following error:

The Tabular database 'XXXXX' is in an inconsistent state and cannot be accessed. Please delete it and recreate it or restore it from a valid backup.

Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-24T17:37:08.91+00:00
Hi @rhei78
Welcome to Microsoft Q&A platform and thanks for posting your query here.

To delete an Azure Analysis Services tabular model that is in an inconsistent state and cannot be accessed, you can use the following steps:

Open SQL Server Management Studio and connect to the Analysis Services instance that contains the tabular model.

In Object Explorer, expand the Databases folder and locate the tabular model that you want to delete.

Right-click on the tabular model and select Delete from the context menu.

In the Delete Object dialog box, select the Delete from Database option and click OK.

If the tabular model is in an inconsistent state and cannot be accessed, you may receive an error message stating that the database is in an inconsistent state and cannot be deleted. In this case, you can try deleting the database using PowerShell.

Open PowerShell and connect to the Analysis Services instance that contains the tabular model.

Run the following command to delete the tabular model: Remove-ASDatabase -Server -Name Replace with the name of the Analysis Services instance and with the name of the tabular model that you want to delete.

If the tabular model cannot be deleted using SQL Server Management Studio or PowerShell, you may need to restore it from a valid backup or recreate it.

Reference: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-create-sample-model#clean-up-resources

I hope this helps! Let me know if you have any further questions.

1 answer

rhei78 0 Reputation points

2025-01-27T22:33:39.9266667+00:00

Thank you @Smaran Thoomu . I already tried to delete the database using SQL Server management studio but it always shows the same message as bellow. As for using Powershell , I can't seem to see the command 'Remove-ASDatabase' from the documentation https://learn.microsoft.com/en-us/analysis-services/powershell/analysis-services-powershell-reference?view=asallproducts-allversions
Please sign in to rate this answer.
Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-29T03:48:38.57+00:00

@rhei78 I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us? In case if you don't have a support plan please let us know here.

Smaran Thoomu 19,390 Reputation points Microsoft Vendor

2025-01-30T13:36:01.32+00:00

@rhei78 We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer