'Restoring data from one partitioned database to another if all partitions are in the same file Group(Primary) in SQL Managed Instance
I have a partitioned database in Azure Managed Instance, all the tables in the database has a column called TenantID and that it what the database has been partitioned on. It has 200 partitions and data in partitions 1,2,3 and all the data is on the primary filegroup, we dont have any other filegroup. How do I go about moving data ONLY for Tenant - 2 (which is in partition 2)from this partitioned database to another partitioned database. Based on what I researched I think having different filegroups would help but in my case all the data is on the primary filegroup.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|