1

I am trying to restore database whose size is around 3 GB to a SQL Server 2017 Express edition, but I keep getting this error:

Msg 1827, Level 16, State 4, Line 11
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database.

Msg 3013, Level 16, State 1, Line 11
RESTORE DATABASE is terminating abnormally.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user6885473
  • 298
  • 1
  • 5
  • 20
  • What is your question? – HoneyBadger Mar 20 '19 at 11:06
  • The error says it all: the restored size would be more than 10 GB, which is the size limit for SQL Server Express. In brief: you **CANNOT** restore this database to an Express edition - you need a Web, Standard or Enterprise Edition of SQL Server to restore it to .... – marc_s Mar 20 '19 at 12:46

1 Answers1

0

SQL Server Express limits the maximum database size to 10GB.

Shrink the database and try.

Mohammed Nawaf
  • 16
  • 1