1

For our SQL servers we run backups onto a shared premium storage disk. Premium storage is locally redundant and I would like to copy these backups to a standard storage disk in order to take advantage of it's Geo-redundancy. What is the best way to do this?

0

The only way that I'm aware of would be to just start copying, robocopy is likely the most efficient method.

However, if you are aware writing backups to local disk uses up your alloted IOPS. It is best practice, and recommended by Microsoft, to use the backup to URL for database backups. Doing this does not count against your IOPS for the disk or VM.

| improve this answer | |
  • Thanks Shawn, I have actually just started using URL backups. – Peuge Nov 14 '16 at 14:32

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.