December 13, 2013 at 11:35 am
Hey guys,
I have a Windows Azure VM with SQL Server installed and I need to know if there's a way to automate restoring a database from the Azure machine to the on premise database nightly? There is no VPN setup.
December 14, 2013 at 5:24 pm
Two options come to mind. First, and possibly not the easiest but certainly the most direct, set up a VPN so that it's part of your network. Second, you can copy from the Azure VM to Azure Blob storage using Azure PowerShell commands. It's pretty straight forward. Then, from the local machine, you can copy from the Blob storage down and then run the restore. That'll work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2013 at 9:31 am
Thanks Grant! I'm going to attempt to create a VPN...
I know this isn't SQL related, but do you know of a way to create a VPN in Azure that will allow me to browse the Azure VM from my local network? If I can get this working I'll just create an SSIS package and do a backup\restore method nightly.
December 17, 2013 at 9:49 am
I know there is a way to do it, yes, but I'm not familiar with it. It's actually something I need to spend some time getting my arms around and I just haven't allocated it into my schedule yet. Sorry.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 17, 2013 at 10:14 am
No problem, thanks for your help!
I'll let you know how it goes 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply