Sql express edition says limit is 10GB but my database has grown more thn 50GB

Vidhyadhar TS 1 Reputation point
2022-05-04T09:18:21.53+00:00

Sql express edition says limit is 10GB but my database has grown more than 50GB and things are working fine and no issues reported.
how to understand this 10 GB limit over growing 50+ GB please advise.

Thanks in Advance

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,750 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dirk Hondong 871 Reputation points
    2022-05-04T10:05:31.69+00:00

    Hi Vidhyadhar,

    take a look at the size of your data file and the log file
    The data file has the 10 GB Limit.
    If your DB is that much larger, then I suppose that you're running the database in Full Recovery mode without taking log backups.
    So you need to take care of a proper backup which includes Full database backup as well as T-Log backups.
    Maybe you take a look at the maintenance solution Ola Hallengren provides. There are examples how to set it up for SQL Srv Express as well.

    Regards
    Dirk

    1 person found this answer helpful.
  2. Vidhyadhar TS 1 Reputation point
    2022-05-04T10:12:53.633+00:00

    Hey Dirk
    Thanks for quick reply!

    I also read somewhere that the recovery model should be simple rather a full recovery? is that true ?

    am not good at db or I just have too minimum knowledge at DBs

  3. Vidhyadhar TS 1 Reputation point
    2022-05-04T10:16:55.63+00:00

    When we say 10GB, it is for the MDF file, which is actually data stored file.
    There is a LOG file called .LDF file, in that its a log file and it can grow until the HDD supports and another, the LDF file growth is restricted to certain limit.

    So here the drive space is set to 299 GB . and if I dont change anything in any of options, can i expect db to grow till 290 GB atleast ?

    How can I truncate the Log file ?

  4. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2022-05-05T02:09:29.483+00:00

    Hi VidhyadharTS-6837,

    In addition, after shrinking the log file, you can have alter database modify file command to set max file size of log file so that the log file will not fill up the drive.
    For example: 

    ALTER DATABASE databasename  
 MODIFY FILE  
 (NAME = logname,  
 MAXSIZE = 100GB);

    And please also remember to monitor the log file size every once in a while. Please refer to Manage the size of the transaction log file for more details.

    Best Regards,
    Amelia

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments