Restore a bak file which is more than 3 GB on a SQL Server 2017 Express edition getting error

Question

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.

Answer 1

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

Shrink the database and try.