-
Notifications
You must be signed in to change notification settings - Fork 10
Table FB_AGPostFailoverDBUsers
EdVassie edited this page Apr 1, 2020
·
2 revisions
| 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 |
|---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP