July 11, 2015 at 7:25 am
For an on-premise sql server we use RedGate tools to backup our databases and then backup the sqb files to tape.
In Azure, for an (unmanaged) Sql Server, we can still use Redgate for backups but how do we automate copying the sqb backups to local (on-premise) storage for long term retention? Or this mode of thinking not right in the
cloud?
TIA,
bd
July 13, 2015 at 5:55 pm
When it comes to long term retention for SQL VM backups, in Azure, you have a couple of options.
If you are using SQL 2012 SP1 or higher:
1) Use backup to URL to backup to Azure Storage and simply keep the backups in Azure storage for long term retention.
2) Use backup to URL to backup to Azure Storage and then create a script to periodically download these backups to on-premise.
3) Azure also provides a backup service, Azure Backup[/url] for backing up VMs. This may meet your needs.
For other SQL Server versions:
If you are storing the backups on a VM disk you could create a network share and access the backups on the VM through a public endpoint or a VPN tunnel.
In the cloud you can store backups (and other files) securely in Azure Storage so it may not be required to build an additional long term retention backup store on-premise.
If you don't mind me asking, what are your requirements for long term retention backups?
Thanks,
-Eli
July 13, 2015 at 8:16 pm
Sounds crazy but we had restored 4 year old DBs hunting for the first monthly appearance of a certain data value in a column
BD
July 15, 2015 at 8:04 am
Four years ago is a while ago, if you don't mind me asking, how did you and your team go about finding what point to restore to?
July 27, 2015 at 4:43 am
You can issue powershell commands to copy the files down provided you set up a VPN so that your Azure servers are operating within your network. I've done the opposite, copy files up to Azure through powershell. That doesn't need the VPN because it's calling Azure commands. But you're just looking to do a file copy basically.
Personally, I wouldn't do this. Instead, I'd take a copy over to Azure storage. Otherwise, you're paying for the download costs to your local machines.
"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
September 18, 2015 at 2:49 pm
Personally I am a big fan of using Azure BLOB store for both short and long term backups.
CEWII
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply