backup for a huge size Database

Question

Hi guys

I have an 8TB database , any idea as to which backup strategy to use , traditional backup will take a very long time to complete and a long time to restore.
The sql version that I have is an old one 2003

Thanks

Answer 1

Hi @kK-2020

I recommend that you use a backup service that allows you to take an initial copy for the database to physically upload to their service. Then you can incrementally backup the changes to the service without the huge overhead associated with such a large amount of data.

You may also benefit from compressing your database:

https://learn.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15

I do hope this answers your question.

-----------

--If the reply is helpful, please Upvote and Accept as answer--