I work on sql server 2008 r2 express edition.

Database error exceeded allowed limit of 10240 MB per database

How to solve?

  • Share the database tables between two DBMSs. And the limit does not win. - nick_n_a
  • 2
    If the server version is not critical, then install the Developer Edition 2014, which is now given for free. If it is a matter of principle, then, as already said, it is necessary to split the initial base into several, or you will have to fork out for a paid edition (we do not consider the option of piracy). - Yaant
  • one
    Well, the backup did not materialize from the air, but was created on some server. It is on that server that you need to modify the database in order to meet the size limit. Then make a new backup and use it. You cannot use the backup you have now in Express Edition. - Yaant
  • This backup is ready. Cannot be changed. - propro17
  • one
    The 2008R2 Standard also has a 524 PB limit ( link ) - i-one

0