Wednesday 27 July 2016

Amazon RDS for SQL Server now supports SQL Server Native Backup/Restore with S3

Amazon RDS for SQL Server now supports SQL Server Native Backup/Restore using Amazon Simple Storage Service (S3). You can now take database level backups as SQL Server backup files (.bak) and store them in your Amazon S3 bucket. SQL Server full backups are commonly used to migrate or move databases among different SQL Server instances, whether in the cloud or on-premises, for data ingestion, disaster recovery and other backup purposes. You can export a full backup of your on-premises database, store it in S3 and then use the custom stored procedures offered by RDS to restore that backup to an existing RDS instance. You will also be able to backup an RDS database into S3 and restore the backup file later onto an on-premises or RDS database. Storing and transferring backup files into and out of AWS through S3 affords customers an added layer of protection for disaster recovery and gives customers a peace of mind that their data can be moved around easily. On RDS, you can encrypt your backup files across SQL Server Express, Web, Standard and Enterprise Editions.



from What's New http://ift.tt/2awgIWI

No comments:

Post a Comment