Troubleshooting
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 free at least 2 MB on the device, or create a new device with at least 2 MB. 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.