469,085 Members | 1,042 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,085 developers. It's quick & easy.

SQL express-solving 4GB size limit by multiple database files?

Hi,

I am new to SQL express and try to solve the 4GB size limitation.
Is there a possibility to create a new database file every time I get
to the limit?
How can I do that with C#? how can I create new database file every
time it gets full?
Can I be connected to two database files at the same time (the full db
and the new db)?

thanks in advance,
oren

Nov 19 '06 #1
1 9150
orenbt wrote:
Hi,

I am new to SQL express and try to solve the 4GB size limitation.
Is there a possibility to create a new database file every time I get
to the limit?
How can I do that with C#? how can I create new database file every
time it gets full?
Can I be connected to two database files at the same time (the full db
and the new db)?

thanks in advance,
oren
The 4GB limit applies to the total size of the database so creating
extra files won't help. You would need to create a new database. You
can issue a CREATE DATABASE command using ADO, DMO, etc.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--

Nov 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bootstrap Bill | last post: by
5 posts views Thread by RDV | last post: by
1 post views Thread by Lubomir | last post: by
17 posts views Thread by vendmacro | last post: by
3 posts views Thread by clintonG | last post: by
3 posts views Thread by msnews.microsoft.com | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.