Configure System DB Management

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.

Top

---

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.

1. Extract all files from SqlSysManagement.Cab into a temporary folder.

2. 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