How to run DBCC CheckDB on SSISDB?

0

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.

AWS
preguntada hace 10 meses243 visualizaciones
2 Respuestas
0
Respuesta aceptada
  • 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.
AWS
respondido hace 10 meses
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].

AWS
respondido hace 10 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas