On Dec 21, 10:29*pm, Erland Sommarskog <esq...@sommarskog.sewrote:
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.