What database should I use for TT&E Web


SQL Server 2000 or SQL Server 2005 is best if you already have it.  You will create the Timeless database on your server during the installation of Timeless Time & Expense Enterprise Web.

SQL Server 2005 Express is a free version of SQL Server 2005.  This version is limited to using one CPU even in a multi-processor machine.  There is also database size limit of 4GB.  Database growth can vary greatly depending on how you use Timeless Time & Expense.  We estimate anywhere from 1-10MB growth per user per year.   You will create the Timeless database on your server during the installation of Timeless Time & Expense Enterprise Web.  You will need to use a separate tool to backup your database.

Timeless MSDE is a free version SQL Server 2000 with some internal limitations.  There is a limit of 5 concurrent database processes executing simultaneously and a 2GB database file size limit.  This usually will not have an impact even in large installations.  Database growth can vary greatly depending on how you use Timeless Time & Expense.  We estimate anywhere from 1-10MB growth per user per year.  You will need to use a separate tool to backup your database.

You will install the Timeless MSDE database server and create the Timeless database during the installation of Timeless Time & Expense Enterprise Web.  The Timeless MSDE database does not have to be installed on your web server.  You may run the Timeless Time & Expense Web installation first to create the database server on one machine, then run the installation again on your web server to install the web application. 


Posted Wednesday, March 21, 2007 by MAG Softwrx, Inc
http://kb.magsoftwrx.com/KnowledgebaseArticle10061.aspx