0

I am trying to migrate a SQL Server 2016 database to a SQL Server 2019 server. The database is huge at about 500 GB. It takes about 3 hours to create a Full compressed Backup of about 300 GB and 2.5 hours to restore the database. The latest differential backup is about 400MB.

I have tied restoring the database, but I am not sure how can I just restore the differential without having to go through the full backup.

Rick
  • 207
  • 2
  • 8

1 Answers1

0

Take the full backup and then recover the full backup and leave it in NORECOVERY mode. This will then allow you to restore the differential backup when you are ready. Check out this article. https://www.sqlmvp.org/restore-database-with-norecovery/ The article explains how this all works. It shows it from the respective of a full and log backup. The process is the same with a differential backup. If you have log backups too, then you can restore the full, restore the differential, restore the log(s).

Definitely also read the article given in the comments. That will give you more to think about and give you a potentially better approach next time.