Wednesday, August 3, 2016

error accomodating a copy of the model database

Problem: Error encountered during installation of vendor software package that includes creation of database

Symptoms: Error message similar to "37000-1803: [Microsoft] [ODBC SQL Server Driver] [SQL Server] The CREATE DATABASE statement failed. The primary file must be at least XXXX MB to accommodate a copy of the model database."

Cause: Vendor has specified a database size in their create database script that is smaller than the size of the "model" database on that instance.

Solution: Shrink model database

No comments:

Post a Comment