RMS Database Size

Bob your database has a gowth factor and to that end the database will add data to the precommited Database size.

If you back up your database and then restore it and make your auto growth to go up to 15 - 20% then it will work with no issue until you hit 2GB.

Ivan

Thanks Ivan!

"Ivan Brebner ..::PRS::.." wrote:

This Begs the Question. What do you when you have hit 1.9GB?

What data is removed? Can it be placed in a reports database?

dp

David,

Coming soon, you will be able to use the new SQL 2005 Express with RMS/MSPOS which allows for 4 gig database sizes.

After that, it depends on what _you_ want to do. I recommend keeping _all_ records (or at least 7 years minimum for taxes), so you would need to upgrade to the full version of SQL 2000 or 2005 for unlimited storage.

Also, there are archive programs to remove some info and store it in a different database. Kinda clunky to look at old info, but does work. Costs about half as much as the full blown version of SQL.

Ok, so the 2GB limit is the "local" MSDE version size limit.

It shouldn't have this limitation with SQL2000, right?

David,

That's correct, but remember that the local copy only contains minimal information. It doesn't store any of the transaction information (except when in Offline mode), purchase and receivings, transfers, etc that the main database stores. When you say local, I'm assuming you mean the Offline database.

Again, with the next update using SQL 2005 Express, the local database will increase to 4 gig.

No size limits in SQL2000 or 2005 Workgroup, Standard or Enterprise editions.

Ozzie,

Same here, its just been unsupported until 1.3R is released later this month.