Amila
Amila

Reputation: 21

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 limit 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?

Upvotes: 0

Views: 1570

Answers (4)

Chains
Chains

Reputation: 13157

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.

Upvotes: 0

user774411
user774411

Reputation: 1809

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)

Upvotes: 1

Zachary
Zachary

Reputation: 6532

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.

Upvotes: 2

KM.
KM.

Reputation: 103579

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

Upvotes: 3

Related Questions