SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Database Restore issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Dhanushkodi
Starting Member

India
21 Posts

Posted - 07/17/2013 :  03:15:40  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 07/17/2013 :  04:20:03  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3712 Posts

Posted - 07/17/2013 :  08:15:37  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000