RDS for SQL Serverのまとめ

RDS for SQL Serverで色々やるときのストアドだったり、SQLだったりをまとめます。

WITH
    PASSWORD = 'Password',
    DEFAULT_DATABASE = test_db,
    CHECK_EXPIRATION = OFF,
    CHECK_POLICY = OFF
GO

GO
CREATE USER developer
GO

GO
EXEC sp_addrolemember 'db_owner', 'developer'
GO

    @source_db_name='database_name', 
    @s3_arn_to_backup_to='arn:aws:s3:::BACKETNAME/FILENAME.bak',
    @type='FULL'

    @restore_db_name='database_name', 
    @s3_arn_to_backup_to='arn:aws:s3:::BACKETNAME/FILENAME.bak',
    @with_norecovery=1,

    @db_name='database_name',
    @task_id=ID_number;