Look into partitioning your data into seperate databases/tables. How you
would partition the data (by year, state, account, etc.) depends on the case
usages of how the data is referenced and how often.
Also explore the possibility of migrating rarely used data to offline
backups. You mentioned that the databases were installed at various remote
locations. If you have remote software, like PC Anywhere, installed at each
site, then you can use the command line version of SQL Server Bulk Copy to
export records to tab delimited format. This could also be easily run by the
client from a batch file or VB script.
BCP mycompany..sales out c:\backup\sales20030905.dat -c -S SERVER -U UID -P
To bulk load the records back into the table, do the following:
BCP mycompany..sales in c:\backup\sales20030905.dat -c -S SERVER -U UID -P
> Is there any way to override 2GB size limit
> for database in MSDE?
> Of course except of buying bigger version of SQLServer
> because the database is used on many computers and it becomes
> greater and greater... I couldn't afford to buy so many
> bigger versions of SQLServers for my clients...And there is rather
> small possibility to lower number of data in database.
> There is a lot of relations between data so it would be
> a great problem with splitting it between several
> Is there any solution?