Post reply

Increasing "space available" in SQL 2005 Express

  • August 28, 2008 at 11:46 am

    #131000

    I have a customer who needed to upgrade from the MSDE version of SQL 2000 to 2005 Express because their db had reached the 2gb max. However, after upgrading the db via detach/attach, the "space available" remains the same (a whole 16 mb's). I increased the MAXFILESIZE to 4gb, but no change. I even ran DBCC UPDATEUSAGE as a long shot. Nada.

    Any ideas?

    Thanks,

    Mark

  • August 28, 2008 at 12:59 pm

    #864642

    Nevermind... the customer had also installed the 2000 MSDE version on the same computer. The database was actually attached to the 2000 instance.

    The moral of the story is, never take the customer at their word : )

    Mark

Viewing 2 posts - 1 through 2 (of 2 total)

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