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.
gefragt vor 10 Monaten242 Aufrufe
2 Antworten
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
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.
beantwortet vor 10 Monaten
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].
beantwortet vor 10 Monaten
Relevanter Inhalt
AWS OFFICIALAktualisiert vor 2 Jahren- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor 7 Monaten
- AWS OFFICIALAktualisiert vor 2 Jahren