1 year ago

#294079

test-img

al_qaysee

AWS RDS Restore HEADERONLY from S3

From RDS AWS, I am not able to restore a database header only from S3 bucket:

RESTORE HEADERONLY  FROM  DISK  = N'arn:aws:s3::myBucket/myDB.bak'

Just to check access, I can restore the full database without errors :

exec msdb.dbo.rds_restore_database 
@restore_db_name='myDBName', 
@s3_arn_to_restore_from='arn:aws:s3::myBucket/myDB.bak'

Is this even possible? what am I missing? Why restore header only is not working ? Any other alternatives ?

enter image description here

sql-server

amazon-web-services

amazon-rds

database-backups

0 Answers

Your Answer

Accepted video resources