how to face Database limitation Issue in SQL Sever Express 2008?

I've decided to develop VB.net Application With SQL server Express 2008, but Microsoft says:

They limi开发者_运维技巧t 4 GB Size per DB!

So I'm developing my app for Single user Desktop pc, so what should I do when the DB reached the Maximum size?

When the DB size reached to maximum size, is it a good thing to create a new DB and allow my vb.net application to work with both DBs?

---

in regards to the 4GB limit of your free version of SQL Server, your options as I see them:

1) purge old data as it becomes unnecessary
2) hack application to use multiple databases (would this even work on a single pc?)
3) hack your application to move items to data files as necessary and out of the DB
4) pay for the proper version of SQL Server
5) go to MySql or something similar

---

SQL Server 2008 R2 Express size limit was increased to 10 GB, so if your just starting a new project you should use 2008 R2.

---

Nothing wrong to attempt for free tools. I suggest that you redesign your application to use multiple databases.

1) Create a new table for storing multiple databases setting data

2) Things to store in that table include: total databases, connection string for each database, and so on.

Consider storing each table in a separate database (where appropriate)

---

If you expect to exceed 4GB (are you sure?) then some options might include...

1. archive older data into a separate database
2. don't use sql-server express -- use a standard version that can grow.