Configure DBA Routines

Previous Create DBA Database	Manual Configuration	Configure Management Data Warehouse Next

FineBuild can configure DBA routines to optimise manageability.

All FineBuild DBA management routines are put into a dedicated database. This database can be used by the DBA to store other routines that they need.

FineBuild DBA Routines configuration

The DBA Routines configuration relates to Process Id 5EC and is controlled by the parameters below:

SQL Version	Parameter	FULL Build	WORKSTATION Build	CLIENT Build
SQL2019	/SetupDBAManagement:	Yes	Yes	N/A
SQL2017	/SetupDBAManagement:	Yes	Yes	N/A
SQL2016	/SetupDBAManagement:	Yes	Yes	N/A
SQL2014	/SetupDBAManagement:	Yes	Yes	N/A
SQL2012	/SetupDBAManagement:	Yes	Yes	N/A
SQL2008R2	/SetupDBAManagement:	Yes	Yes	N/A
SQL2008	/SetupDBAManagement:	Yes	Yes	N/A
SQL2005	/SetupDBAManagement:	Yes	Yes	N/A

In order to maintain compatibility with older versions of SQL FineBuild, the parameter ConfigDBAManagement can also be used.

FineBuild also uses the following parameters to help configure DBA

Parameter	Default Value	Description
DBA_DB	DBA_Data	Name of database for DBA routines

Top

---

Manual DBA Routines Configuration

The following steps show what you would have to do for manual DBA Routines configuration. FineBuild does all of this work for you automatically.

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

2. Run the DBA routines 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
   Proc sp_ScriptRoles.sql	Script Database Roles for any database

   The following routines are added to the DBA_Data database:

   Item	Comment
   Proc spArchiveSuspectPages.sql	Archive suspect_pages data to DBA database
   Proc spCreateAgentProxy	Creates SQL Agent proxy account
   Proc spCreateNewErrorlog.sql	Cycle SQL Server Errorlog
   Proc spDTSExportPackages.sql	Export DTS Packages to a structured storage file
   Proc spDTSImportPackages.sql	Import DTS Packages from a structured storage file
   Proc spDTSReplaceOwner.sql	Replace owner information on DTS Packages
   Proc spResetJobnamesMDW.sql	Change MDW job names to more descriptive format
   Proc spResetJobnamesPBM.sql	Change PBM job names to more descriptive format
   Proc spScriptAlerts.sql	Script SQL Agent Alerts
   Proc spScriptFunctions.sql	Script User Defined Functions
   Proc spScriptJobs.sql	Script SQL Agent Jobs
   Proc spScriptLogins.sql	Script SQL Server Logins
   Proc spScriptMessages.sql	Script SQL User Messages
   Proc spScriptOperators.sql	Script SQL Agent Operators
   Proc spScriptProcs.sql	Script user Stored Procedures
   Proc spScriptTables.sql	Script user Tables
   Proc spScriptViews.sql	Script user Views
   Proc spSetDBOptions.sql	Set standard database options
   Job Archive suspect_pages.sql	Daily archive of suspect_pages data

Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements

Previous Create DBA Database	Top	Configure Management Data Warehouse Next