kseen
kseen

Reputation: 397

A basic SQL Server Backup strategy / tool

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

Answers (1)

TheGameiswar
TheGameiswar

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

Related Questions