Table FB_AGPostFailoverDBUsers - SQL-FineBuild/Common GitHub Wiki
| Previous Proc FB_DBRestore | Table FB_AGSystemDataJobExceptions Next |
|---|
The FB_AGPostFailoverDBUsers table holds details of database user mappings that need to be updated after a Failover
If there are any site-specific user mappings that need to be updated following a failover, they should be added to this table and will be processed automatically by Proc FB_AGPostFailover. The site-specific values can be included in a SQL FineBuild install by using an AutoConfig Script
| Column Name | Data Type | Description |
|---|---|---|
| Id | Integer | Identity value |
| DBName | NVarchar(128) | Database Name |
| DBUser | NVarchar(128) | Database User Name |
| Login | NVarchar(128) | SQL Server Login Name |
This table will be populated by SQL FineBuild with the following rows needed for the Data Quality and the SSIS Catalogue databases:
| DBName | DBUser | Login |
|---|---|---|
| DQS_MAIN | dqs_service | ##MS_dqs_service_login## |
| DQS_PROJECTS | dqs_service | ##MS_dqs_service_login## |
| DQS_STAGING_DATA | dqs_service | ##MS_dqs_service_login## |
| SSISDB | ##MS_SSISServerCleanupJobUser## | ##MS_SSISServerCleanupJobLogin## |
Copyright FineBuild Team © 2020. License and Acknowledgements
| Previous Proc FB_DBRestore | Top | Table FB_AGSystemDataJobExceptions Next |
|---|