Restore full,differential and transaction log backups in RDS

  • Barcelona10

    SSCertifiable

    Points: 5029

    Hi Guys.

    Our company in transition to move to AWS cloud.I created new database on AWS and uploaded full,dif and trn backups of our production database  into S3 bucket.Now i need to am trying to restore all my backups (ull,dif and trn).I use the following script to restore full backup using  SSMS.

    exec msdb.dbo.rds_restore_database

    @restore_db_name='database_name',

    @s3_arn_to_restore_from='arn:aws:s3:::bucket_name/file_name_and_extension';

     

    How do i restore differential and trn backups?

     

    Thank You

     

  • Barcelona10

    SSCertifiable

    Points: 5029

    Hi Guys.

    Our company in transition to move to AWS cloud.I created new database on AWS and uploaded full,dif and trn backups of our production database  into S3 bucket.Now i need to  restore all my backups (full,dif and trn).I use the following script to restore full backup .

    exec msdb.dbo.rds_restore_database

    @restore_db_name='database_name',

    @s3_arn_to_restore_from='arn:aws:s3:::bucket_name/file_name_and_extension';

     

    How do i restore differential and trn backups?

     

    Thank You

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 714708

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply