question

Sumathi avatar image
Sumathi asked

How to migrate SQL server partition databases to new server with no downtime

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

migrationpartitioning
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

anthony.green avatar image anthony.green commented ·

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.

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.