Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 How to increase the data file size?

Author  Topic 

Varun
Starting Member

9 Posts

Posted - 2006-08-02 : 05:50:25
Hi All,
Is it possible to increase the size of data file in SQL Server 2005 Express Edition.
I think the licensed limit is 4096MB whcih i am unable to increase.
Could anyone let if is it possible to increase the data file size and if yes then how?

Thanks,
Varun

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-02 : 06:11:15
You mean beyond the limit?
No but you can create other instances of express.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Varun
Starting Member

9 Posts

Posted - 2006-08-02 : 06:17:00
Yes. Beyond 4096MB.
Is that possible?
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-02 : 06:25:50
No. Not without upgrading to another edition.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

Varun
Starting Member

9 Posts

Posted - 2006-08-02 : 06:30:06
Thanks Nigel!
Go to Top of Page
   

- Advertisement -