Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200)
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)
For example, this issue may occur in the following scenarios.
- 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.
- 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 informationThe following file is available for download from the Microsoft Download Center:
Download 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 servicesMicrosoft 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.
文章 ID：3179258 - 上次审阅时间：08/17/2016 07:14:00 - 修订版本： 1.0
Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core, Microsoft SQL Server 2016 Standard
- kbqfe kbfix kbsurveynew kbexpertiseadvanced atdownload KB3179258