How to run DBCC CheckDB on SSISDB?

Question

I have enabled SSIS on a RDS SQL Server, database SSISDB was created automatically.

Because the master user is not member of dbo of this DB, I can't run DBCC CheckDB on it.

Please advise whether any workaround to do so, thank you.

Accepted Answer

- 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.

Answer

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].

How to run DBCC CheckDB on SSISDB?

相關內容