SQL Express Considerations

This help file applies to an out-of-date version of MainBoss.
The most recent version of MainBoss is MainBoss 4.2.4.
This help file does not exist in MainBoss 4.2.4, but the index for that version can be found here.

< Previous section | Table of Contents | Index | Next section >

SQL Express is a free version of SQL Server. It is freely available from Microsoft. For up-to-date information on downloading SQL Express from Microsoft, go to

http://www.mainboss.com/info/microsoft.htm

SQL Express will provide acceptable performance for small sites. Larger sites should buy one of the larger versions of SQL Server.

We should note that SQL Express lacks some features of paid-for versions of SQL Server. For example, SQL Express does not have automatic maintenance plans, Microsoft's facilities that simplifies automatic backups and integrity checks. However, expressmaint is a free software package that provides some of the functionality that's missing in SQL Express. For more information, see

http://www.sqldbatips.com/showarticle.asp?ID=27

The expressmaint package is not a Thinkage or Microsoft product. Neither MainBoss Support nor Microsoft will provide any support for this package.

The rest of this appendix describes considerations for installing and working with SQL Express.