Share via

Migration of SQL transfer from ver 2005 to 2008 SP2 with Restore failed with exceed limit of 10240MB

Siow, Jiong Cheng 0 Reputation points
2025-01-22T11:37:57.5633333+00:00

Good Day, I will like to ask question how do overcome the Restore failed with exceed limit of 10240MB

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,389 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
547 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,776 Reputation points
    2025-01-22T11:41:02.9+00:00

    Restore failed with exceed limit of 10240MB

    Then you have installed the free Express Edition of SQL Server; that one has a database size limit of 10 GB.

    Note: Version 2008R2 is out-of-support size a very long time.

    0 comments
  2. LiHongMSFT-4306 30,511 Reputation points
    2025-01-23T03:16:55.48+00:00

    Hi @Siow, Jiong Cheng

    Are you migrating to SQL Server 2008 Express Edition? The Express edition has a database size limitation of 10 GB per database.

    You need to upgrade to a non-Express edition (like SQL Server 2008 Standard or Enterprise) in order to restore a database larger than 10 GB.

    Or you can consider reducing the size of the database before performing the migration.

    Best regards,

    Cosmog

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.