Create DBA Database - SQL-FineBuild/Common GitHub Wiki
| 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 |
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 |
|---|