Post reply

Max Database Size for MSDE

  • November 2, 2007 at 7:15 pm

    #70387

    It is assumed the max database size for MSDE 2000 is 2GB. But actually I am able to save more than 2 GB to an MSDE database, now its size is 4400.88 MB (running sp_spaceused). I am confused. What is the actual size limit for MSDE?

  • November 3, 2007 at 6:00 am

    #747999

    peterwliu (11/2/2007)

    It is assumed the max database size for MSDE 2000 is 2GB. But actually I am able to save more than 2 GB to an MSDE database, now its size is 4400.88 MB (running sp_spaceused). I am confused. What is the actual size limit for MSDE?

    ...The 2GB limit applies to the total size of the data file(s), not the log file(s)

    ...However a log file over 2GB is not going to have any benefits.

    --Ramesh

  • November 3, 2007 at 8:26 am

    #748004

    sp_spaceused is not that accurate if u havent used DBCC UPDATEUSAGE for a while. But u should use sp_helpdb , so that u can get space of ur datafile saize and logfile size separately.

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

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