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)
 SQL Server Express Constraint

Author  Topic 

pradeep_iete
Yak Posting Veteran

84 Posts

Posted - 2010-02-23 : 08:59:27
HI All,

I have SQL server Express running at store .That instance have 4 database running.Now my question is :

1) Does the constraint of Maximum 4 GB of database size is applicable for per Database case OR Summ of ALL database should be summed up and should not exceed 4 GB.

2) Database Size is defined as MDF + LDF?

3) IF System is terrible low like approaching the constraint of size, What should be the solution ?
4) I have one table which increased erraticly and lead to Truncate table in 3 months time ,then what could be solution for that.I must tell you that the table are inevitable pasrt of Databse ?

Thanks



   

- Advertisement -