Sample Header Ad - 728x90

SQL Server Express mdf file is 50+gb

1 vote
1 answer
129 views
I have a SQL Server Express database running on a POS register where the mdf file is 50+gb. When I run select @@version I get: >Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Express Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 15063: ) I'm confused by this as I thought SQL Server Express has an mdf file limit of 10GB. Is there something I'm missing? SELECT type_desc, physical_name FROM sys.database_files; returns: type_desc|physical_name -|- ROWS|C:\Program Files\Microsoft SQL Server\MSSQL14.POS\MSSQL\DATA\master.mdf LOG|C:\Program Files\Microsoft SQL Server\MSSQL14.POS\MSSQL\DATA\mastlog.ldf I limited the ldf file to about 8GB.
Asked by Sean Harricharan (11 rep)
Jul 17, 2024, 01:05 PM
Last activity: Aug 4, 2024, 10:40 AM