Post reply

Database Size In SQL Server 2005 Express Edition

  • July 27, 2010 at 11:59 pm

    #238138

    Can someone please let me know whether the .mdf file size is limited to 4 GB or the full database size itself?

    I have installed SQL Server Express Edition on one of my servers and the database size itself is 21 GB and working absolutely fine.

    With Thanks,

    Satnam

  • July 28, 2010 at 12:53 am

    #1199085

    Database size limit of 4 GB in sql express 2005 only applies to Data file (.mdf) not for log files (.ldf)

    As per MSDN

    "The 4 GB database size limit applies only to data files and not to log files."

    please visit this link

    http://msdn.microsoft.com/en-us/library/ms345154(SQL.90).aspx

    So you can have log file of any size but be careful with data file since its limit is 4GB and your data file will not be allowed to grow more than that even if you have mutiple data files for a single database.

    Thanks,

    Amit Kulkarni

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

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