Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


You do one of the following:

  • Restore a SQL Server Analysis Services (SSAS) database (of compatibility level 1200)

  • Attach an SSAS database (of compatibility level 1200)

  • Restart a server that contains an SSAS database (of compatibility level 1200)

If you process one of the partitions of any table in this database, data loss may occur in other partitions of the same table. The partitions that were explicitly processed do not lose data. Only the other partitions in that table lose data.

For example, this issue may occur in the following scenarios.

Scenario 1

  • You restart an instance of SQL Server 2016 that contains an SSAS database of compatibility level 1200 that contains a table that has a single partition.

  • You add a partition to the table, and then you process only the newly added partition.

  • The previously existing partition in the table loses data.

Scenario 2

  • You restore an SSAS database of compatibility level 1200 (that has a multi-partitioned table) from a backup.

  • You process a single partition in the table.

  • The other partitions in the table lose data.


Download information

The following file is available for download from the Microsoft Download Center:
DownloadDownload the package now.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.


To work around this issue, run a full process of the table after the database is restored.


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Learn about the terminology Microsoft uses to describe software updates.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!