I have the following situation: Our sql server is running in a cloud service. The database to be backed up have 60gb. We need to make a local copy of the database for some tests, and it need to be up to date, but 60gb is impracticable to download daily.

We thought to make a full backup, download it one time, make differential backups in following days. Once a week, we can stop the database operations to make the last differential backup from last week full backup and make a full backup, and start again the database operations. In this moment, the local bd, when restored with the last diff backup (made when the db was with stopped operations), have the same data than the last week full backup.

The idea behind this is, if is possible to use the diff backup from last full backup and restore it in our local database. If it is not possible, anyone have some idea of what we can do to get all the data, up to date, from our cloud database?

  • 1
    Have you done anything to the local copy of the database in the meantime? If so, you're going to have to keep the original full backup around, restore that, and then apply any diffs. So you can do it without re-downloading the initial backup, but you can't do it without restoring the original backup. – Aaron Bertrand Sep 3 '13 at 13:32
  • SQL Server 2005 in a cloud service? If you have full access to the server (I assume it's a VM?), could you set up log shipping? – Jon Seigel Sep 3 '13 at 13:38
  • @JonSeigel we have access to the cloud, it is a VM. Can you show some links about this? – Eduardo Lion Sep 3 '13 at 14:51
  • @AaronBertrand can you explain better your idea? – Eduardo Lion Sep 3 '13 at 14:52
  • 1
    The documentation is pretty thorough. If you're having specific problems setting it up, I would recommend asking a new question here with all the relevant details. – Jon Seigel Sep 4 '13 at 17:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.