Reputation: 397
I have a SQL Server 2014 running on Windows Server 2012 R2. I want to back it up daily and store backups on some remote cloud storage for reliability. Basically, that is all of my requirements.
Is there a tool that can help with this? The easier and plainer the better.
Upvotes: 1
Views: 167
Reputation: 28860
I don't see any app providing native support for cloud backups.But you can use SQLServer 2014 to backup to cloud using SQLServer Agent
Below are steps
1.create credential
CREATE CREDENTIAL MyCredentialName
WITH IDENTITY = 'MyStorageAccountName',
SECRET = 'MyAccessKey';
2.Backup
BACKUP DATABASE MyNewDB TO
URL = N'http://myserver.blob.core.windows.net/scarybu/MyNewDB.bak'
WITH CREDENTIAL = N'MyCredentialName',
NAME = N'MyNewDB-Full Database Backup', STATS = 10;
You could also experiment by adding compression ,checksum to above syntax by looking at all options..You can see below link for more experiments and results done by Jovan Popovic :Native database backup in Azure SQL Managed Instance..You can ignore copy_only syntax in the link examples,since it is only for managed instances
Upvotes: 2