sql differential backup onto onedrive

Question

sql differential backup onto onedrive

tarekj

SSC Journeyman

Points: 78
More actions
May 21, 2017 at 9:33 am

#330609

How can I make automated sql differential backup onto onedrive?

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99143 More actions · Answer 1

tarekj - Sunday, May 21, 2017 9:33 AM
How can I make automated sql differential backup onto onedrive?

I'm not sure there's a direct way to do it. You could install the OneDrive application, and set it to automatically synchronise the folder you save your back ups to. Then you'll have a local and cloud copy.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

tarekj SSC Journeyman Points: 78 More actions · Answer 2

This will copy the whole file every time I sync it which is 10 GB!

Thom A SSC Guru Points: 99143 More actions · Answer 3

tarekj - Monday, May 22, 2017 6:09 AM
This will copy the whole file every time I sync it which is 10 GB!

You'll need a copy of the whole file anyway. If your differential file is 10GB, then only uploading part of it is going to corrupt it and makes it useless.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

tarekj SSC Journeyman Points: 78 More actions · Answer 4

Then what is the best practice to backup sql database to the cloud?

VastSQL SSC-Dedicated Points: 36278 More actions · Answer 5

You can include Log backup to your plan and upload the files to onedrive the same way you do for Differential. Keep in mind if you need to restore you need the Full ,Differential and Txion log backups

Thom A SSC Guru Points: 99143 More actions · Answer 6

tarekj - Monday, May 22, 2017 7:43 AM
Then what is the best practice to backup sql database to the cloud?

Uploading the files frequently, and in full. If you're only going to be uploading part of your back up strategy in the cloud, and you lose your physical media, then your cloud backup is useless. Much like having a copy of all your files in a same locked key safe at a different site seems like a good idea. If you only have one key and that is lost/stolen, your second copy of your files is as useless as your first, as you can't access either.

Why are you aiming to only back up some of your files to the cloud? What benefit do you see yourself gaining from that? I assume your reasoning is so that you also have an off site back up of your database, which, as I suggested, means you want to keep a copy of everything. If storage is a concern, then store the full backups only on the cloud, and if you have to restore from them be aware that data will likely be lost. To start a restore process you need at least a full back up, then any differentials and finally transactional. Starting with only (or both) differential or transactional backups will get you no where.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk