Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Database Restore issue

Author  Topic 

Dhanushkodi
Starting Member

21 Posts

Posted - 2013-07-17 : 03:15:40
Hi Everyone,

I am get the following error while restore the database.

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per

My database size is 6 GB.

took the back up from 2008 server and restore to 2008 server.

please help me to clear out.

thanks,
Dhanushkodi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-17 : 04:20:03
Seems like issue is with limit of your SQL 2008 instance where you're trying to restore. Drop some unwanted dbs if you've them in instance or go for upgraded edition with higher size limit.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-07-17 : 08:15:37
quote:
Originally posted by Dhanushkodi

Hi Everyone,

I am get the following error while restore the database.

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per

My database size is 6 GB.

took the back up from 2008 server and restore to 2008 server.

please help me to clear out.

thanks,
Dhanushkodi

My immediate reaction would have been to ask if you are using the Express edition. However, if you are on SQL 2008 (and not SQL 2008 R2) your limit would have been 4 Gigs, not 10 Gigs. What is the exact version and edition of SQL Server you are using? Run this query to find out:
SELECT @@version;
Go to Top of Page
   

- Advertisement -