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 2008 Forums
 SQL Server Administration (2008)
 SQL Express 2008 R2 db size limitation

Author  Topic 

dkekesi
Starting Member

38 Posts

Posted - 2011-12-20 : 04:06:44
Hi All,

I know that SQL Express 2008 limits database size in 4GB. What I do not know if the log ldf files also count into this 4GB or only the mdf + ndf file sizes matter?

Thanks for your help.
Daniel

Sachin.Nand

2937 Posts

Posted - 2011-12-20 : 05:12:32
I think it is the total data size excluding log space for each database.But overall data space size cannot increase more than 10 GB for a given instance.

PBUH

Go to Top of Page

dkekesi
Starting Member

38 Posts

Posted - 2011-12-20 : 05:14:48
Thanks Sachin.
I also just found that log files are excluded (and yes, DB size is 10GB).

Best Regards,
Daniel
Go to Top of Page
   

- Advertisement -