DBS03-AWS201.md

DBS03-AWS201 - SQLServer Native Backup and Restore on RDS

Cloud Service Provider

• Amazon Web Services

Difficulty

• Level 200 (Intermediate)

Project's Author(s)

• Jagan

Objectives

You need to complete the following:

• Enable native backup and restore on RDS
• Take native SQL Server backup to S3 bucket
• Restore native backup from S3 bucket

You need to answer the following:

• How to migrate database from on-prem to RDS?
• How to restore database from native SQL Server backup?
• How to take manual backup on RDS?

References

• How to perform native backups of an Amazon RDS DB instance?
• Setting Up for Native Backup and Restore
• Working With Backups
• Running SQL Server Databases on Amazon RDS for SQL Server - AWS Virtual Workshop
• Amazon RDS Free Tier

Costs

• Included in the Free Tier
• 750 hours of Amazon RDS Single-AZ db.t2.micro included in free tier

Estimated time to complete

• 45-60 minutes

Tips

• Having database knowledge is an added advantage