This project has moved. For the latest updates, please go here.

Previous Create DBA Database Manual Configuration Configure Management Data Warehouse Next

Configure DBA Routines

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:

Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
SetupDBAManagement FULL Yes Yes Yes Yes Yes
SetupDBAManagement WORKSTATION Yes Yes Yes Yes Yes
SetupDBAManagement CLIENT N/A N/A N/A N/A 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 Routines:
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 © 2014 Edward Vassie. License and Acknowledgements
Previous Create DBA Database Top Configure Management Data Warehouse Next

Last edited Dec 31, 2014 at 10:50 AM by EdVassie, version 3