Зараз ви перебуваєте в автономному режимі; очікується повторне підключення до Інтернету

Processing a partition causes data loss on other partitions after the database is restored in SQL Server 2016 (1200)

Symptoms
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.
Resolution

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.
Workaround
To work around this issue, run a full process of the table after the database is restored.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
References
Learn about the terminology Microsoft uses to describe software updates.
Властивості

Ідентифікатор статті: 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
Зворотний зв’язок