I have SQL Server 2008 Express edition installed on server. It has two database. One database (say "A" has database size around 10 GB) and other is around is around 7 GB.
I have already set file grow to unrestricted. I believe Express edition has limitation of 10 GB per database so now.
How do i increase the allocation of .MDF file?? I tried to reindex the table which are consuming maximum index space but it gave me error:
Msg: 1101, Level 17, State 1, Line 1
Could not allocate a new page for database 'A' because of insufficient disk space in file group primary.
I also tried to add new primary group file but it does not allow.
What is the possible solution to this? I heard even Enterprise edition also have 10 GB database restriction, is this correct? If yes, please suggest a solution.