Using Db Maint, Working with…

Log Details

The log details dialog presents information of a selected log entry.

Database

The database for which the message was generated.

Jobname

The name of the job for which the message was inserted.

Starttime

The time when the message was generated.

Command

The SQL command which generated the message.

Errortype

INFORMATION, WARNING or ERROR. The classification is the same as when SQL Server writes messages to the event log.

Severity level < 15 are logged as INFORMATION

Severity level = 15 are logged as WARNING

Severity level > 15 are logged as ERROR

Severity

The SQL Server severity level (if any).

Error

The SQL Server error number (if any).

Error desc

The actual SQL Server error message (if any). Only the first 255 characters are stored.

Export options

You can export this information to a text file. This is useful for problem determination purposes. This information can be saved and sent to your support provider, for example. Choose what to be included in the report and press the Export button. The file can also be sent as an attachment to an email.

View DB Structure (only for 6.5)

Presents the data and log allocation structure at the time he task was run. Each run will save the structure to the msdb..dbmsysusages table. The structure is presented as a series of CREATE DATABASE, ALTER DATABASE and sp_logdevice commands.

This information is useful when you have to recreate a database in order to load a backup.

Choose the applicable database in the list and press the Database structure button.