Sql-server – I can’t restore the database on SQL Server 2012. Exceeds size

restoresql serversql-server-2012

I'm trying to restore a database from a .bak file. The file is only 89.3 mb large. I'm using the restore with replace option, so that all other data in the database is removed. We are just trying to get the latest data from out clients.

But I get an error saying that I will exceed my limit of 10GB. My server instance is, using

select @@version:

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)   
Feb 10 2012 19:39:15   
Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Could someone please tell me why I can't get my database to restore. Do I have to get the full version of 2012? We are using the Express version

Best Answer

Express Edition limits the size of the database to 10 GB.

The backup is small because it only contains pages that are used -- regardless of whether or not the backup is compressed -- but the original file sizes will be restored to the size they were when they were backed up. The file sizes are what count against the limit.

Assuming this is the problem, the only solutions are to shrink the files before taking the backup, or restore the backup on a different edition (probably Developer edition).

Related Solutions

Sql-server – Update only the oldest entry in a table with foreign key criteria

Yes, your query will update all rows in posts. You have to include a condition that restricts the update to one row. One way to do this:

UPDATE Posts 
SET Content = @Content 
WHERE Id = 
    (SELECT TOP 1 Id 
     FROM Posts 
     WHERE FkThreadId = @Id 
     ORDER BY CreationTime ASC) ;

In SQL-Server, you can't update two tables in one statement, so you have to use two statements. You can put them inside a transaction though, so they are treated as an atom, they either both succeed or fail.

Sql-server – Differentiate SQL Server Express from SQL Server installed in a server

The MSSQLSERVER name in the services does not mean anything other than SQL Server (any edition) was installed as the default (unnamed) instance. It does NOT give you any information as to what version or edition it is! This can be SQL Server Express!

You need to connect to that database instance and run

SELECT @@VERSION

to find out what exact version/edition it is.

Having the two SQL Server service entries just means you have two instances - which edition each instance is cannot be determined from their names alone. OK - SQLEXPRESS is the default name used for SQL Server Express - but you could install a Standard or Enterprise edition with that instance name - just for fun.

Best Answer

Related Solutions

Sql-server – Update only the oldest entry in a table with foreign key criteria

Sql-server – Differentiate SQL Server Express from SQL Server installed in a server

Related Question