Post reply

Upgrade from SQL 2005 EXPRESS to SQL 2008 EXPRESS

  • September 4, 2010 at 7:23 am

    #387732

    Hello friends,

    I restored My database in SQL 2005 of size more than 4 GB but it creates problem when i save picture (image data) in database.i.e i can't save it.So i searched for that problem and came to know that SQL Express 2005 has database size limit of 4 GB.

    i upgraded it to SQL EXPRESS 2008 and restored it to there.Still it has the same prblem means i can't able to save data..

    So what may be the problem.

    Thanks in advance.

    RAHUL PATEL.

    rahulpatel112@gmail.com

  • September 4, 2010 at 8:47 am

    #1216530

    Did you also install SSMS for SQL 2008?

    1. Open SSMS - right click on the database name.

    2. In the drop down list that appears - Select "Properties"

    3. In the next window that appears - in the left pane click on "Files"

    4. In the right pane examine the column titled "Initial Size"

    5. Is it set to more than 4 GB? If not increase the "Initial Size"

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • September 5, 2010 at 11:28 pm

    #1216764

    Thanks for your reply.

    i upgraded sql 2005 express to sql 2008 EXPRESS WITH TOOLS that is

    R2 version of SQL EXPRESS.

    I also updated the initial size of database.

    But still the same problem....

  • September 6, 2010 at 5:52 am

    #1216888

    Thanks a lot dear for your valuable time.

    I have installed SQL EXPRESS 2008 but it was not EXPRESS R2 version thats why its creating problem.

    I came to know that thing when i was changing the initial size of database to 5500 MB.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply