Configure DBA Routines - SQL-FineBuild/Common GitHub Wiki

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