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 simplify automatic backups and integrity checks.

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