Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Azure to On-premise Expand / Collapse
Author
Message
Posted Friday, December 13, 2013 11:35 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:10 AM
Points: 251, Visits: 225
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.
Post #1522816
Posted Saturday, December 14, 2013 5:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1522995
Posted Tuesday, December 17, 2013 9:31 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:10 AM
Points: 251, Visits: 225
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.
Post #1523773
Posted Tuesday, December 17, 2013 9:49 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1523783
Posted Tuesday, December 17, 2013 10:14 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:10 AM
Points: 251, Visits: 225
No problem, thanks for your help!

I'll let you know how it goes
Post #1523798
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse