Configure System DB Management - SQL-FineBuild/Common GitHub Wiki
| Previous Configure Full-Text options | Manual Configuration | Configure DBA Database Next |
|---|
A number of routines can be installed to assist in managing SQL Server.
FineBuild System DB Management configuration
The System DB Management configuration relates to Process Id 5EA and is controlled by the parameters below:
| SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
|---|---|---|---|---|
| SQL2019 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2017 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2016 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2014 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2012 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2008R2 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2008 | /SetupSysManagement: | Yes | Yes | N/A |
| SQL2005 | /SetupSysManagement: | Yes | Yes | N/A |
In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigSysManagement can also be used.
Manual System DB Management Configuration
The following steps show what you would have to do for manual Configure System DB Management. FineBuild does all of this work for you automatically.
-
Extract all files from SqlSysManagement.Cab into a temporary folder.
-
Run the system DB Management Install script to create the following maintenance routines.
A single set of these routines is created for each SQL Server instance:
The following routines are added to the master database:
Item Comment MSG Messages.sql Add standard messages to master database. This file can be updated to contain other messages used by the site. Proc sp_GetEnvVarValue.sql Get specified Windows environment variable value The following routines are added to the model database:
Item Comment UDT Hugemoney.sql Adds Hugemoney data type The following routines are added to the msdb database:
Item Comment Alert BasicSetup.sql Alerts for errors with severity 17 and above Alert Login Fail.sql Raise an alert if an attempted login fails. Repeated failed logins can indicate an attempt to subvert SQL Server security. Alert Login sa Success.sql Raise an alert for a successful login using the sa account. Unless such a login is expected, this situation is normally a breach of security. Job Create New Errorlog Cycle the SQL Server Errorlog every midnight Oper SQL_Alerts.sql SQL Agent Operator to process DBA Alerts
Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements
| Previous Configure Full-Text options | Top | Configure DBA Database Next |
|---|