Installation

Db Maint Configuration

Welcome to the Db Maint Configuration program. This program creates, upgrades and removes 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 structure is compatible with. You can upgrade from version 2 and version 3. If you have an earlier version of Db Maint, then download 2.0 or 3.0 and upgrade to that version first.

The program enables/disables choices depending on the status of the current Db Maint system tables.

Select the desired option.

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 again, press “Check Version”, and Db Maint will perform a version check and enable/disable the command buttons accordingly.

Truncate Db Maint log.

This option will be presented if you are using SQL Server 6.5, and if Db Maint find that you might be low on space in your transaction log.

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 x.x to 4.0.

You will not lose 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 and start fresh.

Drop all Db Maint tables.

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

Status

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