?
Solved

Error 1827

Posted on 2004-11-09
8
Medium Priority
?
8,804 Views
Last Modified: 2008-01-09
error 1827: create/alter database failed because the resulting cumulative database size would exceed your licensed limit of 2048 MB per database.

I'm trying to copy a database to my local machine and I get this error.  How do I resolve it?
I saw this link, but didn't help: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q216812


Thanks!
0
Comment
Question by:sticar
  • 4
  • 4
8 Comments
 
LVL 8

Expert Comment

by:SashP
ID: 12534879
Have you shrunk your database recently?

You are using MSDE I assume?

There is no workaround for the size limit, it is a built in limit.  You may need to upgrade to SQL Server.
0
 
LVL 8

Expert Comment

by:SashP
ID: 12534893
DBCC SHRINKDATABASE
Shrinks the size of the data files in the specified database.

Syntax
DBCC SHRINKDATABASE
    ( database_name [ , target_percent ]
        [ , { NOTRUNCATE | TRUNCATEONLY } ]
    )

Arguments
database_name

Is the name of the database to be shrunk. Database names must conform to the rules for identifiers. For more information, see Using Identifiers.  

target_percent

Is the desired percentage of free space left in the database file after the database has been shrunk.

NOTRUNCATE

Causes the freed file space to be retained in the database files. If not specified, the freed file space is released to the operating system.

TRUNCATEONLY

Causes any unused space in the data files to be released to the operating system and shrinks the file to the last allocated extent, reducing the file size without moving any data. No attempt is made to relocate rows to unallocated pages. target_percent is ignored when TRUNCATEONLY is used.

0
 
LVL 8

Expert Comment

by:SashP
ID: 12534922
sticar,

I doubt that shrinking the database will acheive much. Perhaps you could look at archiving some data.

If you are creating a new database select a size less than 2048MB.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:sticar
ID: 12535155
I don't have any databases in my local db yet.  I'm copying one from another database and it says mine is too small.  Aparently I must have MSDE.  I should be able to get ahold of SQL Server.  I loaded my local db a long time ago so not sure.  Do I have to uninstall MSDE somehow and re-install SQL Server ?
0
 
LVL 8

Accepted Solution

by:
SashP earned 2000 total points
ID: 12535245
You are restoring a database for another server that is larger than 2GB to a MSDE installation?

If so ...  not possible.  Solution:  Install SQL Server or restore database to a machine with SQL Server (not MSDE)

Sash
0
 

Author Comment

by:sticar
ID: 12535976
Ok, will do!  Thanks all!
0
 

Author Comment

by:sticar
ID: 12536114
I definitely have SQL Server installed, and I just installed it again.  I'm still getting the same error. ?
0
 

Author Comment

by:sticar
ID: 12536153
Nevermind.  I reloaded it and it worked. :)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question