Posted by David Portas on 11/19/06 20:18

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/ms130214(en-US,SQL.90).aspx
--

• Next in forum: SQL Server 2000 + 2005 working on same windows 2003 server as seperate instances
• Prev in forum: SQL express-solving 4GB size limit by multiple database files?
• Thread view: Re: SQL express-solving 4GB size limit by multiple database files?

[Reply to this message]