This content has been marked as final. Show 3 replies
If you hit the 2GB celing w/ MSDE, another option to consider is just running an in-place upgrade to SQL 2005 Express which has a 4GB limit.
One of the motivations for us to upgrade EPO to 4 was the compatibility with 2005 Express since we have been dealing with the database size issue for the past several months.
Right on, that one I missed out on :rolleyes:
I've just installed 2005 Express next to the MSDE and manually moved the database.
All I really had to do according to this is to upgrade ...... well you learn each day.
But IF one would change to for example Sql 2005 or Sql2008 one would have to do as I said from the beginning. :)
Another thing I learned now was that express limit is 4Gb!!!
What do you think about that UNVNettech?
Since my installation reached 2Gb after only 6 month, how fast will it not grow to 4Gb?
Since I took over our EPO installation about a year and a half ago, we have been hovering around the 2GB mark the entire time. Major PITA and there is no $$ for a full SQL install.
We upgraded to 4.0 this week and as of today, the database is sitting at 2.04 GB. The ability to grow the database past 2GB is critical for us and eliminates the need to constantly comb through to make space. We run several other Express instances and the biggest hassle would be the lack of maintenance plans (which you can work around, check the web). It will be interesting to see how the DB grows with the new version.