PrepAway - Latest Free Exam Questions & Answers

14 Comments on “Does Amazon RDS for SQL Server currently support importing data into the msdb database?

  1. nadeem says:

    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
  2. sureshkurapati says:

    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
  3. niyiallen says:

    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
  4. W M Stair says:

    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

Leave a Reply

Your email address will not be published. Required fields are marked *