Backup MS SQL Database to Azure with RedGate

Hello,

Is it possible to backup MS SQL database directly to MS Azure with RedGate? I searched around and could not find any info on that.

Thank you for your input.
Tagged:

Best Answer

  • Eddie DEddie D Posts: 1,805 Rose Gold 5
    Hi, thank you for your forum post.

    Have I understood the question correctly that you wish to back up a local on-premise database to a network share on located on MS Azure? If the answer is no, please reply with further information.

    If the answer is yes, personally I am inclined to say no for performance reasons. A backup directly to a network share has a bigger overhead compared to backing up to a local disk and then copying the backup file to a network share.

    In theory it maybe possible providing the account given to the SQL Backup Agent service has security permissions to the share located on Azure. It has never been tested and there certainly are no plans to test such a configuration to my knowledge.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com

Answers

Sign In or Register to comment.