This project has moved and is read-only. For the latest updates, please go here.

Previous Configure Full-Text options Manual Configuration Configure DBA Database Next

Configure System DB Management

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:
Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupSysManagement FULL Yes Yes Yes Yes Yes
SetupSysManagement WORKSTATION Yes Yes Yes Yes Yes
SetupSysManagement CLIENT N/A N/A N/A N/A 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.

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 © 2014 Edward Vassie. License and Acknowledgements
Previous Configure Full-Text options Top Configure DBA Database Next

Last edited Aug 1, 2014 at 3:18 PM by EdVassie, version 1