Posted by Mike on 12/27/07 17:39

On Dec 21, 10:29 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:

> > 2007-12-21 11:49:40.37 spid9s      Could not create tempdb. You may
> > not have enough disk space available. Free additional disk space by
> > deleting other files on the tempdb drive and then restart SQL Server.
> > Check for additional errors in the event log that may indicate why the
> > tempdb files could not be initialized.
>
> That doesn't look good. When in single-user mode, have you verified
> that the path for tempdb is good?
>
> Also, if you moved the files to the new place, make sure that they are
> not read-only for the service account for SQL Server? You could try
> deleting the files - SQL Server will recreate them anyway.

Thanks for the reply. Hope you had an excellent Christmas too!

I've had a look in the innards of SQL.

There is no entry for tempdb is master.dbo.sysdatabases. (I have
1=master, 3=model and 4=msdb).
There are 2 entries in master.dbo.master_files:

SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('tempdb');

gives me

tempdev D:\MSSQL\Data\Tempdb.mdf
templog C:\MSSQL\Logs\Templog.ldf

Both the directories exist, and everyone has complete access to them
(just to be sure...)

I suspect I'm scuppered because the entry for tempdb in sysdatabases
has gone AWOL. Am I looking at a restore/reinstall?

Mike.

[Back to original message]