Migrating Large Size scale Database

Question

Migrating Large Size scale Database

Urbel 585

Hi all,

what is alternative method to migrating side by side large size Database

thanks for all reply

regards,

Urbel

Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator

2026-02-24T22:25:21.02+00:00

Can you be more specific? Are you migrating from on-Prem to Azure? Or something else? The more information you can share about your migration project, the better your chances for a precise answer.
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator

2026-03-09T04:54:15.2933333+00:00
Hi @Urbel,

As mentioned by the @Erland Sommarskog , more details about the migration scenario would help the community provide accurate guidance. For example:

Source and target SQL Server versions

Whether the migration is on-premises to on-premises, on-premises to Azure, or another environment

Downtime tolerance

Whether technologies like Backup/Restore, Log Shipping, Always On, or Database Mirroring are options in your environment

Since the database size is ~11 TB, the migration approach can vary significantly depending on these factors.

Please share a bit more information about your setup so the community can suggest the most suitable method.

Thanksm
Akhil.
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator

2026-04-16T06:19:15.2766667+00:00

Hi @Urbel,

Just checking back could you please share a few more details about your migration setup (source/target versions, migration type, and downtime window)?

This will help suggest the best approach for your 11 TB database.

Thanks,
Akhil.
Urbel 585 Reputation points

2026-04-16T06:32:07.16+00:00

Hi all,

thanks for its valued respond,

the database is on -premise and plan to migrate to on-premise, the size of Database is almost 10TB and my organization tolerance for downtime, what is technology will be used, I need to know from you of all...

great thanks

warm regards,

UrBel

2 answers

Your answer

Erland Sommarskog 133.7K Reputation points MVP Volunteer Moderator

2026-02-24T22:25:21.02+00:00

Can you be more specific? Are you migrating from on-Prem to Azure? Or something else? The more information you can share about your migration project, the better your chances for a precise answer.
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator

2026-03-09T04:54:15.2933333+00:00

Hi @Urbel,

As mentioned by the @Erland Sommarskog , more details about the migration scenario would help the community provide accurate guidance. For example:

Source and target SQL Server versions

Whether the migration is on-premises to on-premises, on-premises to Azure, or another environment

Downtime tolerance

Whether technologies like Backup/Restore, Log Shipping, Always On, or Database Mirroring are options in your environment

Since the database size is ~11 TB, the migration approach can vary significantly depending on these factors.

Please share a bit more information about your setup so the community can suggest the most suitable method.

Thanksm
Akhil.
Akhil Gajavelly 1,735 Reputation points Microsoft External Staff Moderator

2026-04-16T06:19:15.2766667+00:00

Hi @Urbel,

Just checking back could you please share a few more details about your migration setup (source/target versions, migration type, and downtime window)?

This will help suggest the best approach for your 11 TB database.

Thanks,
Akhil.
Urbel 585 Reputation points

2026-04-16T06:32:07.16+00:00

Hi all,

thanks for its valued respond,

the database is on -premise and plan to migrate to on-premise, the size of Database is almost 10TB and my organization tolerance for downtime, what is technology will be used, I need to know from you of all...

great thanks

warm regards,

UrBel

Answer 1

Erland Sommarskog 133.7K MVP Volunteer Moderator

the database is on -premise and plan to migrate to on-premise, the size of Database is almost 10TB and my organization tolerance for downtime, what is technology will be used, I need to know from you of all...

BACKUP/RESTORE would be the normal thing to do. To reduce downtime, first restore a full backup with NORECOVERY, and then do log shipping until the cutover.

0 comments

Answer 2

For migrating large size databases side by side, one alternative method is to use the Azure Database Migration Service. This fully managed service enables seamless migrations from multiple database sources to Azure data platforms with minimal downtime. It is particularly useful for large-scale migrations as it supports various database types and can handle significant data volumes efficiently.

Additionally, you can consider using the Azure Data Factory pipeline feature for offline migrations. This method is suitable for large data sizes and allows you to migrate data from on-premises databases to Azure SQL Database or SQL Server on Azure VM. It involves creating a data factory or using an existing one, configuring the necessary integration runtime, and monitoring the migration process through the Azure portal.

Both methods provide robust options for managing large database migrations effectively.

Share via

Migrating Large Size scale Database

2 answers

Your answer