Error 1814

Severity Level 10
Message Text

Could not create tempdb. If space is low, extend the amount of space and restart.

Explanation

This error occurs when there is not enough space on the device to create the tempdb database.

Action

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, Microsoft® SQL Server™ sends an “out of memory” message (you can ignore this message) and then moves tempdb to RAM automatically.

See Also

Errors 1000 - 1999

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.