You must Sign In to post a response.
  • Category: Windows 10

    How to solve this limit file issue


    I restore a .bak file from a Employee Database that I need to Restore, but the Restore exceeds licensed limit of SQL Server 2014 10240 MB per database

    How to Fixed it in Sql server 2014 version

    any one guide me.

    i tried following Query but no luck not working raise above error only any one do and let me know

    ALTER DATABASE mydb MODIFY FILE (name = N'logical_name', size = 2048MB);
    DBCC SHRINKFILE(logical_name, 2048);
  • #767960

    The only way would be to restore to an edition of SQL Server besides the express edition, then delete the data that you don't need. Then shrink the database below the 10 GB limit then backup and restore to your express instance.

    If this is for a development machine look at getting a copy of SQL Server Developer Edition. It's usually about some dollar amount and doesn't have any limitations like database size. It's only limitation is that you can't use the instance for production use.


Sign In to post your comments