Error 1803 Failed to Create Database

Asked By jacob ethan 0 points N/A Posted on - 01/13/2012

I am trying to create a new database and start the Upsizing Wizard as I need to upsize my database to SQL Server 2005.  

But a Server Error 1803: CREATE DATABASE failed. Primary file must be at least 3MB to accommodate a copy of the model database. appeared on doing it.

What is the cause of this and how to resolve this?

The error message is shown below.

Any help will do.

Thanks.

• Status: Open
• Question Views: 1400
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Aristono Martin

Go To Solution

Best Answer

Best Answer

Answered By Aristono Martin 20 points N/A #124081

Error 1803 Failed to Create Database

Hi Jacob Ethan,

The server error 1803 is coming up when we create a database and there is not enough space on the database. What you may try to do is to create the database on a different disk or delete some files to free the disk space.

If you are getting the error on the tempdb database, make sure to transfer the tempdb database on a device with large enough disk space to occupy the server. SQL will not start so you may need to start using –f minimum option configuration to try to free some space on the disk.

 Aristono

About Aristono Martin

Questions
3

Answers
370

Best Answers
53

• Vote Up 0 Vote Down

• Posted on - 01/13/2012
• Question Category: MySQL Server

Answered By Riley weaver 10 points N/A #124082

Error 1803 Failed to Create Database

Hello Jacob,

SQL server error 1803 is actually a space error. You have to have some more space than 3MB to create new database. You can export some database from the model and can free up some space.

Also you can shrink the database, it will also help to freed up some space. Sometimes because of temp file it shows some problem to create database. You can check about the space by this script, “SELECT name, size/128.0 – CAST (FILEPROPERTY (name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files;”( without quotes.)

Thank you,

Riley Weaver.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 12/11/2012
• Question Category: MySQL Server