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.
| 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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
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; |
|
|
|
|
|
|
Database Restore issue