Amazon RDS for SQL Server – Support for Native Backup/Restore to Amazon S3
by Jeff Barr | on 27 JUL 2016
1
0
nadeemsays:
Support for Native Backup/Restore
You can now take native SQL Server database backups from your RDS instances and store them in an Amazon S3 bucket. Those backups can be restored to an on-premises copy of SQL Server or to another RDS-powered SQL Server instance. You can also copy backups of your on-premises databases to S3 and then restore them to an RDS SQL Server instance.
B is the Correct Answer
0
0
seenagapesays:
I agree with the answer. A
0
0
mdzsays:
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb database.
Note
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb databas
0
0
niyiallensays:
Importing and Exporting SQL Server Data Using Other Methods
Following, you can find information about importing your Microsoft SQL Server data to Amazon RDS, and exporting your data from an Amazon RDS DB instance running SQL Server, by using snapshots.
If your scenario supports it, it is easier to move data in and out of Amazon RDS by using the native backup and restore functionality. For more information, see Importing and Exporting SQL Server Databases.
Note
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb database.
A
Amazon RDS for SQL Server does not currently support importing data into the msdb database, though we do support SQL Server Agent jobs. Some SQL Server features that use the msdb database, such as Database Mail and Replication, are not currently supported in Amazon RDS.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html#SQLServer.Procedural.Importing.Procedure
1
0
A
0
0
This has changed since July 2016, see https://aws.amazon.com/blogs/aws/amazon-rds-for-sql-server-support-for-native-backuprestore-to-amazon-s3/
Amazon RDS for SQL Server – Support for Native Backup/Restore to Amazon S3
by Jeff Barr | on 27 JUL 2016
1
0
Support for Native Backup/Restore
You can now take native SQL Server database backups from your RDS instances and store them in an Amazon S3 bucket. Those backups can be restored to an on-premises copy of SQL Server or to another RDS-powered SQL Server instance. You can also copy backups of your on-premises databases to S3 and then restore them to an RDS SQL Server instance.
B is the Correct Answer
0
0
I agree with the answer. A
0
0
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb database.
0
0
AMAZON RDS doesn’t support importing data to MSDB
FAQ
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
1
0
A is the answer
0
0
Yes . A is the answer . I tested it . It does not allow to add anything to any of the system – master , msdb , tempdb and rdsadmin – databases.
0
0
Thanks bhai.. Lots of jugaad on this QA
0
0
A
0
0
Clearly stated in this page http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
Note
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb databas
0
0
Importing and Exporting SQL Server Data Using Other Methods
Following, you can find information about importing your Microsoft SQL Server data to Amazon RDS, and exporting your data from an Amazon RDS DB instance running SQL Server, by using snapshots.
If your scenario supports it, it is easier to move data in and out of Amazon RDS by using the native backup and restore functionality. For more information, see Importing and Exporting SQL Server Databases.
Note
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb database.
Source:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
0
0
The correct answer is A (no).
Amazon now supports SQL Server native backup and restore, but NOT for the >>MSDB<< (aka system) database.
0
0