Hi,

I'm building a SQL-VB6 application. Some of the clients already have SQL server - others don't and have no plans to do so. For these clients, I want ot use MSDE.

However, I have a few concerns:

1. Does the 2GB Size restriction apply to just the mdf file or the combined size of the mdf and ldf files?

2. This is a reconciliation app where, in some cases, over 20,000 or more records will be imported per day to two "DailyReconciliation" tables. Then, once the reconciliation for the day is complete, reconciled transactions are moved to an "Archive" table, and unreconciled transactions are carried forward to the next day. Adding and deleting this volume of transactions is going to cause the log file to expand very quickly. For this app, there is no benefit of adding to the log file when importing records on a daily basis.

Can I turn the transaction logging off during the file import? Or, can I programatically truncate the log file periodically (from VB)? Or, is there a better solution to this that perhaps someone here has implimented for a situation such as this?

Note: Due to the size limitiations, I am already keeping the archived data in a seperate database. My concern is the log file size and MSDE size restrictions.

Al