Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
We are using dev server for developing and once we are done we some times right click the database and delete or Run Delete Script. But database are not deleted from physical memory (Program Files\Microsoft SQL Server\MSAS11.TABULAR\OLAP\Data\). How can we delete Tabular Model Database from instance and server at the same time
Thank you,
Vicky
Hi @vickyprudhvi,
Based on my test, when I connect to Analysis Services instance in SSMS and delete the tabular database, the database file is deleted from the location: Program Files\Microsoft SQL Server\MSAS11.TABULAR\OLAP\Data\. After the database is deleted from the instance then refresh files in this location to see if it's disappeared.
By the way, for the question about SSAS issue, you can post the thread in SQL Server Analysis Services forum to get dedicated support.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |