Error 1814

Severity Level 10

Message Text

Problem creating Temporary Database - if out of space, please extend and reboot. If some other problem, please contact Technical Support.

Explanation

This error occurs when there is not enough space on the device or in RAM (depending on the current setting of the tempdb_in_ram configuration option) to create the tempdb database.

Action

The procedure for handling this error depends on the current setting of the tempdb_in_ram configuration option.

If the tempdb_in_ram configuration option is set to true (1)

If you moved tempdb to RAM and you don't have enough memory on the server computer to create the IN_RAM device for tempdb, SQL Server will not start. Correct the problem by starting SQL Server with minimum configuration (using the -f option). For details, see Microsoft SQL Server Setup.

If the tempdb_in_ram configuration option is set to false (0)

If you moved tempdb from RAM back to any default device and you don't have enough space on the device (2 MB), SQL Server will attempt to create tempdb on another device. If you do not have a device with at least 2 MB free, SQL Server will not start.

You can create a new device with at least 2 MB or free at least 2 MB on the device. If you create a new device, make sure it is specified as a default device, as in the following example:

sp_diskdefault new_device_name, defaulton

If no default device is specified, SQL Server sends an "out of memory" message (you can ignore this message) and then automatically moves tempdb to RAM.