1

I have a database hosted on SQL Server Express 2017. The size was small like 200MB. Today I have copied 24GB tables to the same database from external database hosted on different server.

The surprising thing is that everything is working perfectly! As far as I know that size limitation of a database hosted on SQL Server Express 2017 is 10GB. Can someone please help me understand what I am missing?

Edit: When I run: sp-spaceused on the same database I get this output: Database_size: 24510.38 MB

18
  • Please add below info in the question. Please check database size by running below command in the database --> use db_name go exec sp_spaceused go Commented May 9, 2019 at 9:13
  • Database_size: 24510.38 MB that's the output
    – Nano
    Commented May 9, 2019 at 9:15
  • 2
    Are you using FILESTREAM or FILETABLE data? Neither of those are included in the 10gb limit. Commented May 9, 2019 at 9:19
  • Can please run SELECT @@VERSION?
    – pim
    Commented May 9, 2019 at 9:19
  • Are you sure you connected to correct database. What is output of select @@version
    – Shanky
    Commented May 9, 2019 at 9:21

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.