Welcome
Installation

Db Maint Configuration

Welcome to the Db Maint Configuration program. This program creates, upgrades and removed the Db Maint system tables. Please refer to the Db Maint documentation for information on table and stored procedure names.

Introduction

When you login to a SQL Server at startup, a check will be performed to see if the Db Maint system tables exists in the msdb database. You will be presented a status in the textbox, describing if each table exists, and what version(s) of Db Maint the table is compatible with

The program will enable/disable choices, depending on the status of the current Db Maint system tables.

Select the desired option and press OK.

Unattended execution

Db Maint configuration can create tables in unattended mode. This is useful for scripting installation. The program accepts one command line switch: /P<password>, where password is the password for sa. The switch is case sensitive and the password must be entered immediate after the letter P. Example (assuming password is “Hello”):

DbmConf /PHello

DbmConf will log successful creation of the Db Maint tables to the NT Eventlog (with a source of “VBRuntime”).

If anything goes wrong during unattended execution (tables already exists, wrong password etc.), a message box will be presented even though the program is executed in unattended mode.

Check Version

If you logoff a SQL Server and logon to some other SQL Server, press “Check Version”, and Db Maint will perform a version check and enable/disable the radio buttons accordingly.

Drop old Db Maint stored procedures.

This option is only visible if you are upgrading from Db Maint 1.5. It will drop stored procedures that 1.5 were using. Db Maint does not install any stored procedures. You will be presented with a message box, which lists the name of the stored procedures that will be dropped.

Truncate Db Maint log.

This option will be presented if you are upgrading from Db Maint 1.5, and if Db Maint finds that you might be low on space in your transaction log.

OK

This is the button that actually performs the creation, upgrade or delete of the Db Maint system tables.

Create Db Maint tables (no Db Maint tables found)

This option will only be enabled if no Db Maint tables were found. Select this when you are installing Db Maint on an SQL Server for the first time.

Upgrade Db Maint tables from 1.5 to 2.0.

You will not loose your Db Maint configuration. It is strongly recommended that you run the Db Maint client and verify Server Properties, Job and Task settings, though.

Recreate tables.

This option will drop all the Db Maint tables and create them again. This is useful if you want to “scratch” your Db Maint installation.

Drop all Db Maint tables.

All Db Maint tables will be deleted from the msdb database.

Location of dbm.exe on server

Make sure that this textbox specifies the location of dbm.exe on the SQL Server machine. You can also configure this setting from the Db Maint client (Server Properties). You have the option to browse the tables, the file list dialog presents the files on the SQL Server machine.

Status

This textbox presents the status of the Db Maint tables in the msdb database.


DbmConf
Installation

Db Maint Configuration

Welcome to the Db Maint Configuration program. This program creates, upgrades and removed the Db Maint system tables. Please refer to the Db Maint documentation for information on table and stored procedure names.

Introduction

When you login to a SQL Server at startup, a check will be performed to see if the Db Maint system tables exists in the msdb database. You will be presented a status in the textbox, describing if each table exists, and what version(s) of Db Maint the table is compatible with

The program will enable/disable choices, depending on the status of the current Db Maint system tables.

Select the desired option and press OK.

Check Version

If you logoff a SQL Server and logon to some other SQL Server, press “Check Version”, and Db Maint will perform a version check and enable/disable the radio buttons accordingly.

Drop old Db Maint stored procedures.

This option is only visible if you are upgrading from Db Maint 1.5. It will drop stored procedures that 1.5 were using. Db Maint does not install any stored procedures. You will be presented with a message box, which lists the name of the stored procedures that will be dropped.

Truncate Db Maint log.

This option will be presented if you are upgrading from Db Maint 1.5, and if Db Maint finds that you might be low on space in your transaction log.

OK

This is the button that actually performs the creation, upgrade or delete of the Db Maint system tables.

Create Db Maint tables (no Db Maint tables found)

This option will only be enabled if no Db Maint tables were found. Select this when you are installing Db Maint on an SQL Server for the first time.

Upgrade Db Maint tables from 1.5 to 2.0.

You will not loose your Db Maint configuration. It is strongly recommended that you run the Db Maint client and verify Server Properties, Job and Task settings, though.

Recreate tables.

This option will drop all the Db Maint tables and create them again. This is useful if you want to “scratch” your Db Maint installation.

Drop all Db Maint tables.

All Db Maint tables will be deleted from the msdb database.

Location of dbm.exe on server

Make sure that this textbox specifies the location of dbm.exe on the SQL Server machine. You can also configure this setting from the Db Maint client (Server Properties). You have the option to browse the tables, the file list dialog presents the files on the SQL Server machine.

Status

This textbox presents the status of the Db Maint tables in the msdb database.