2 Respuestas
- Más nuevo
- Más votos
- Más comentarios
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.
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].
respondido hace 10 meses
Contenido relevante
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace un año
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 2 años