Does Amazon RDS for SQL Server currently support importing data into the msdb database?
A.
No
B.
Yes
Does Amazon RDS for SQL Server currently support importing data into the msdb database?
Does Amazon RDS for SQL Server currently 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
A
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
As per Jeff Barr Blog,
You can now take native SQL Server database backups from your RDS instances and store them in an AMAZON S3 BUCKET.
BUT the Question is asking if it supports importing data into the MSDB database!
And following link clearly states that “Amazon RDS for Microsoft SQL Server does not support importing data into the msdb database.”
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
Therefore answer should be A – NO.
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
I agree with the answer. A
Amazon RDS for Microsoft SQL Server does not support importing data into the msdb database.
AMAZON RDS doesn’t support importing data to MSDB
FAQ
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.Snapshots.html
A is the answer
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.
Thanks bhai.. Lots of jugaad on this QA
A
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
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
The correct answer is A (no).
Amazon now supports SQL Server native backup and restore, but NOT for the >>MSDB<< (aka system) database.