Create DBA Database

Previous Configure DBA Database	Manual Configuration	Configure DBA Routines Next

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:

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 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](DBA_Data);
  ALTER  DATABASE [DBA_Data](DBA_Data) SET RECOVERY SIMPLE;
END;

Copyright FineBuild Team © 2014 - 2019. License and Acknowledgements

Previous Configure DBA Database	Top	Configure DBA Routines Next