DBInsight's Blog

Archive for Database Backups

SQL Server Backup to/Restore from AWS S3 Storage

The use of AWS S3 storage to store SQL Server backups makes sense, firstly it is significantly cheaper than EBS, secondly you can encrypt what’s stored and thirdly you can manage backup file retention and lifecycle using inbuilt functionality. Whether you decide to backup to local EBS disk first for performance then copy to S3 […]

Continue Reading →

Posted in: AWS, Cloud, Database Backups, DBA, SQL Server Tools

Leave a Comment (0) →

Protect Your SQL Server Backups in the Cloud

Consider the following situation, you create a database backup on a AWS virtual machine EBS disk and then move the backup file to Blob storage e.g. S3. However, you have switch on the Encryption option for your S3 storage. Is your database backup file fully protected? Yes, well, sort of. There is that chance, a […]

Continue Reading →

Posted in: AWS, Cloud, Database Backups, SQL Security

Leave a Comment (0) →

Moving a SQL Cluster using Log Shipping

I recently had the requirement to configure log shipping in a SQL 2008 R2 Standard Edition environment. In my scenario, we needed to move a two node cluster to another floor but also attach it to a new SAN, have minimal downtime, no data loss and use the current server hardware. Database mirroring was not […]

Continue Reading →

Posted in: Database Backups, Log Shipping, PowerShell, SQL Server Tools

Leave a Comment (0) →