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

Previous Configure DBA Database Manual Configuration Configure DBA Routines Next

Create DBA Database

FineBuild can create the database to be used to host the DBA routines.

FineBuild Create DBA Database

The Create DBA Database process relates to Process Id 5EB 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 Create DBA Database

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

Create the DBA_Data database by running the following commands. Within FineBuild, these commands are held in the DB Create DBA_DB.sql file. Edit the script to ensure the path names are compatible with the instance on which the database is being installed.

IF NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'DBA_Data')
BEGIN
  CREATE DATABASE [DBA_Data]
  ALTER  DATABASE [DBA_Data] SET RECOVERY SIMPLE
END

Copyright © 2014 Edward Vassie. License and Acknowledgements
Previous Configure DBA Database Top Configure DBA Routines Next

Last edited Dec 31, 2014 at 11:47 AM by EdVassie, version 3