By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Why we can't restore individual databases from RDS SQL Server backups

0

Hi Team,

We know that we can restore entire RDS SQL Server from backups. Can we restore particular database from RDS SQL Server backups. I hope this backups are snapshot backups so we can't restore the individual databases. Can you please let us know if we can restore databases not RDS.

Topics
DatabaseStorage
Tags
Microsoft SQL ServerBackup & RecoveryAWS BackupDatabaseAmazon RDS for SQL Server
Language
English
Sanjeev_Reddy
asked 6 months ago639 views
1 Answer
1

RDS restore will restore the entire instance, not the individual SQL Server databases. To do this you can use the native SQL Server backup technique.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html

AWS
MODERATOR
philaws
answered 6 months ago
profile picture
EXPERT
Giovanni Lauria
reviewed 6 months ago
  • Sanjeev_Reddy
    6 months ago

    Thanks phil but we can't take the databases log backups, we can take the Full and Differential backups for RDS

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content