asked on

Can't restore db

I'm trying to restore a db on a different server and get:

System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database. (Microsoft.SqlServer.Smo)

So I went in and deleted all the db on that server and it still won't let me restore.

Any Ideas?

ASKER CERTIFIED SOLUTION

lcohan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hrolsons

ASKER

That was my thought too so I clicked Help-About, and both say Microsoft SQL Server 2008 R2.

SOLUTION

lcohan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dbaSQL

Yep, definitely check your version, as lcohan suggested, or with this:

SELECT
      SERVERPROPERTY('Edition') [Edition],
      SERVERPROPERTY('ProductLevel') [ProductLevel],
      SERVERPROPERTY('ProductVersion') [ProductVersion]

Also, take a look at these. There's a lot of back and forth on the same error you are having, both suggesting it's a limitation violation with Express edition.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9b78f63e-d785-43be-bed6-4f5ec445cdc0/problem-while-restoring-database-in-sql-server-2008-r2?forum=sqlservermigration

http://stackoverflow.com/questions/3159136/what-happens-when-you-hit-the-sql-server-express-4gb-10gb-limit

hrolsons

ASKER

They both say the same thing:

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550...

The computer might have had Express on in previously. I wonder if a setting in the registry is wrong.

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

dbaSQL

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hrolsons

ASKER

Sorry, I didn't know there was more. I suspected with the "..." but it wouldn't let me scroll over. So I copied and pasted into notepad and low and behold:

"Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Express Edition with Advanced Services (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) "

So you all were a million percent right!!! So should I install the normal on top of express or uninstall express and install the normal version?

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial