How to solve this limit file issue

Joined:	29/05/2009
Level:	Gold
Points:	10380

Points:	4

Hi

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);

Joined:	18/12/2008
Level:	Gold
Points:	2921

Points:	3

Hi,

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.

Thanks,
Mani

How to solve this limit file issue

About dotnetspider.com

Quick Links

General

Services