We have databases that have partitions among multiple servers. Need best solution with steps to migrate those databases with same partitioning to new servers without downtime for application
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Can you explain your setup please?
SQL cannot partition databases across multi servers. (Unless you have sharding enabled, but that points to Azure)
It can partition tables across 1 or more files, but nothing across servers.
Answers Answers and Comments
17 People are following this question.
Partitioning using Lookup function
How do I Move Data from RO to RW Partition
SQL SERVER MIGRATION
Migration of Databases from one server to another!!!
DTS migration trouble