How to solve this limit file issueHi
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);