Increasing the Size of the MQIS

If you need to increase the size of the MQIS after you have installed MSMQ, you can do so using Microsoft SQL Enterprise Manager. Typically, you should expand both the data device and the log device. The log device should be approximately 15 percent of the size of the data device.

The data and log devices on each MSMQ controller server should be the same size. For example, if you choose to have a 75 MB data device and a 12 MB log device and your enterprise has one PEC, two PSCs, and three BSCs, then all six computers should have a 75 MB data device and a 12 MB log device.

Note The MSMQ limited version of SQL Server version 6.5 is limited to a cumulative total of 100 MB in database files. The SQL master database is 30 MB, which leaves 70 MB for a maximum MSMQ database of 60 MB (with 10 MB for the logging of MSMQ database updates).

1. Open SQL Enterprise Manager.
2. On the Manage menu, click Database Devices.
3. Double-click the MQISData graph bar.
If you don't see the MQISData graph bar, use the scroll bar on the right side of the window to find it.
4. Change the Size value, and then click Change Now.
5. Double-click the MQISLog graph bar.
If you don't see the MQISLog graph bar, use the scroll bar on the right side of the window to find it.
6. Change the Size value, and then click Change Now.
7. Close the Manage Database Devices window.
8. On the Manage menu, click Databases.
9. Double-click the MQIS graph bar.
If you don't see the MQIS graph bar, use the scroll bar on the right side of the window to find it.
10. Click Expand.
11. In Data Device, click MQISData.
12. In Log Device, click MQISLog.
13. Click Expand Now.

For information on using Microsoft SQL Enterprise Manager, see the Microsoft SQL Server documentation.

© 1997 by Microsoft Corporation. All rights reserved.