Database Has HGit 4Gb Limit

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Fill Up the Database (I have about 500 movies)
2.Too Much Fan Art.

Please answer the following questions (if they apply):

What is the expected output? What do you see instead?

What is the OML Version? x86 or x64?
x64

How did you add the movie?
DVD/Video Scanner

Did you import from within the VMC UI, command line or DB Editor?
DB Editor

Please provide any additional information below.

I think basically a feature to allow me to eliminate the extra fan art to
make room for more critical info in the DB. 
An option to DL only 1 backdrop per film. And an option to erase all but 1
from the current collection.

PS. Love the project so far.
mostlycarbon@gmail.com

Original issue reported on code.google.com by mostlyca...@gmail.com on 8 Nov 2009 at 4:03

[GoogleCodeExporter]

I have the same problem. My database has reached 4gb from DVD cover art and a 
couple thousand movies. I learned that the issue is that SQL Server Express 
only allows databases up to 4gb in size. Since OML is currently set up to work 
with SQL Server Express, all OML databases have that 4gb limit. Once that limit 
is reached, nothing new can be added to the database, making OML unusable. 

Is there a fix for this? 

Original comment by tmst...@gmail.com on 8 Feb 2011 at 10:42

[GoogleCodeExporter]

I resolved the problem. Here's the fix: Download and install MS SQL Serves 2008 
Express R2 (emphasis on the R2). The original release only supports 4GB 
databases, but R2 supports databases up to 10GB in size. 

So I installed R2, then backed up and restored my OBL database to the new R2 
server, manually created a user profile and manually edited the OML 
settings.xml to point to the new server with new user profile security data. 

Then I opened up OML and presto chango, I now have another 6GB of space to work 
with. 

It would be great if future releases of OML could integrate with the MSSSE 2008 
R2 version so that 10GB becomes the new OML standard. 

Original comment by tmst...@gmail.com on 8 Feb 2011 at 10:18