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
 General SQL Server Forums
 New to SQL Server Administration
 SQL express 2008 R2 - db size

Author  Topic 

shilpaprele
Starting Member

6 Posts

Posted - 2012-10-01 : 01:29:28
I am using express edition of SQL 2008 R2. As per the microsoft sites we can have max DB size as 10GB. But in my sql servere DB property page current size is 15GB.

I dont know how this is possible. Do you have any idea?

komkrit
Yak Posting Veteran

60 Posts

Posted - 2012-10-01 : 09:58:37
DB Properties Page show DB Size as sum of data files size plus log file size.
Check only your data file size is it growth beyond 10GB?
I think log file size has no limitation but datafiles limited.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Komkrit Yensirikul
Welcome for all questions. Let us know if our solution solved your problem.
Go to Top of Page
   

- Advertisement -