2 Answers
- Newest
- Most votes
- Most comments
0
- The RDS SQL Server system database maintenance job runs DBCC CHECKDB on the system databases (master, msdb, rdsadmin, mssqlsystemresource and model) every day.
- The system databases are managed by AWS, so the DBO role of them cannot be granted to the user logins.
- SSISDB is regarded as a system database, that is why we cannot grant dbo role to another customer logins.
- But it is missing in the daily RDS SQL Server system database maintenance job currently.
- The above information means that DBCC CHECKDB cannot be run on SSISDB at this stage.
- The fix is being worked out, once it is ready, SSISDB will be included in the daily system database maintenance job.
answered 9 months ago
0
It is not currently possible to run DBCC CHECKDB on SSISDB in RDS SQL Server as users are not allowed db_owner permission on SSISDB.
The same holds true for [rdsadmin_ReportServer] and [rdsadmin_ReportServerTempDB].
answered 9 months ago
Relevant content
- asked 2 years ago
- Accepted Answerasked 2 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 19 days ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago