Knowledge Base

What database should I use for TT&E Web

Expand / Collapse
 

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. 



Rate this Article:
     

Add Your Comments


Comment require login or registration.

Details
Last Modified:Wednesday, March 28, 2007
Last Modified By: MAG Softwrx, Inc
Type: INFO
Article not rated yet.
Article has been viewed 2,821 times.
Options