1

I am trying to restore a 12g .bak file to a local location and getting an error saying I cant do anything over around 4g. Is there anyway to increase the size of the location?

I have done some reading and from what I have seen you cant increase the size of the location, only the size of the .bak file. The situation is not one where I can change the size of the .bak file.

Thanks for having a look, any help is greatly appreciated.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Regan
  • 23
  • 3
  • 3
    Are you restoring this .bak file to a SQL Express instance? – nathan_jr Aug 08 '12 at 23:55
  • Please define "local location" and "size of location." – GSerg Aug 08 '12 at 23:55
  • I am restoring to an express instance and the error I get is: System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft.SqlServer.Smo) – Regan Aug 08 '12 at 23:59
  • 4
    That is because Express version of 2008 has limitation 4 GB on database size. You can try Express 2008R2 or 2012. They have limitation 10 GB. – Igor Borisenko Aug 09 '12 at 00:10
  • @lgor -- But is .Bak file size is 12gb – AnandPhadke Aug 09 '12 at 06:23

1 Answers1

2

It looks like you're using SQL Server Express, which has database file size limited to 10GB (4GB for SQL Server 2008 Express or earlier). See this question for exhaustive discussion and pointers.

Community
  • 1
  • 1
Krzysztof Kozielczyk
  • 5,887
  • 37
  • 28