User's Manual

Microsoft SQL Server 2005 Express 93

ATTENTION

As the SQL Server tends to expand the transaction log file, Nortel recommends

that you use the steps in the following procedure.

In the following windows, the instance name is MESSENGER\SQLEXPRESS.

Use the instance name of your environment.

Procedure 22

Reducing size of the transaction log ﬁle

Step Action

1 To clean up the transaction log, open the command line and

execute the OSQL tool. Print in the command line of this tool

the offered command with appropriate parameters, including the

instance name, user name, and password.

The following figure appears.

If DBCC command returns an error, ignore the error.

2 Change database model to simple (no use of transaction log).

The following figure appears.

Nortel Communication Server 1000

DECT Messenger Installation and Commissioning — Book 1

NN43120-301 02.01 4 June 2010