4 Replies Latest reply on Nov 3, 2015 10:19 AM by Joe Piotrowski

    Running sqlserver_master.bat in BladeLogic 8.7

    Joe Piotrowski

      This is the output from running the sqlserver_master.bat file to create the schema for the BSA database in 8.7. Some of the output seems new to me from the past. Does this look like a clean install?

       

      C:\downloads\db_scripts\sqlserver>sqlserver_master.bat serverName\BSA87 BSA_DB bladelogic xxxxxxxx

       

      PARAMETERS SET

      Server: serverName\BSA87

      Database: BSA_DB

      Login: bladelogic

      Password: xxxxxxxx

      INSTALL OM SCHEMA

      create sql server schema

      create sql server functions

      create sql server views

      create sql server triggers

      create sql server stored procedures

      create sql server core data

       

      (1 rows affected)

      create sql server core data

       

      (1 rows affected)

      create sql server core data

       

      (1996 rows affected)

      Checking identity information: current identity value '2100000511', current column value '1'.

      DBCC execution completed. If DBCC printed error messages, contact your system administrator.

      create sql server additional indexes

      create sql server constraints

      set sql server options

       

      INSTALL CLEANUP SUITE

      create schema elements

      installing cleanup functions

      installing cleanup stored procedures

      Create index on FKs

       

      (1 rows affected)

      Caution: Changing any part of an object name could break scripts and stored procedures. x3

       

      (1 rows affected)

      Caution: Changing any part of an object name could break scripts and stored procedures. x197

       

      (609 rows affected)

      Creating db maintenance schema elements

      Table dbm_module Created

      Table DBM_MODULE_OBJECT_TYPES Created

      Table DBM_MODULE_TABLES Created

      Table dbm_run Created

      Table dbm_run_module Created

      Table DBM_RUN_MODULE_INPUT Created

      Table dbm_run_module_steps Created

      Table dbm_object_mapping Created

      Table dbm_run_log Created

      Table dbm_status Created

      Table dbm_err Created

      View V_SNAPSHOT_JOB_RUN Created

      View V_PATCH_JOB_RUNS Created

      View V_OBJECT_OVERFLOW Created

      Table dbm_Run_PCT Created

      Table dbm_keep_job_run_ids Created

      Table DBM_KEEP_JOB_RESULT_IDS Created

      Table DBM_KEEP_CR_RESULT_IDS Created

      Table DBM_KEEP_COMP_RESULT_IDS Created

      Table DBM_KEEP_ASSET_RESULT_IDS Created

      Table DBM_KEEP_CONDITION_RESULT_IDS Created

      Table DBM_RETENTION_STAT Created

      Table DBM_KEEP_PSI_BL_VALUES Created

      Table DBM_JOBRUN_STAT Created

      Table DBM_JOB_VIEW_DENOM Created

      Table DBM_RETENTION_SCENARIOS Created

      Table DBM_ONLINE_CUSTOM_PROCESS Created

      Creating db maintenance schema Foreign Key Constraints

      The module 'dbm_online_retention_util_pop_dbm_input' depends on the missing object 'dbm_gather_jobrun_stat'. The module will still be created; however, it canno

      t run successfully until the object exists.

      The module 'dbm_online_retention_util_pop_dbm_input' depends on the missing object 'dbm_gather_jobrun_stat'. The module will still be created; however, it canno

      t run successfully until the object exists.

      Inserting db maintenance Core Data

       

      (1 rows affected)

       

      (0 rows affected)

       

      (0 rows affected)

       

      (1 rows affected)

       

      (1 rows affected)

       

      SQL SERVER SCHEMA INSTALL COMPLETED

       

      C:\downloads\db_scripts\sqlserver>