Posted by Erland Sommarskog on 12/27/07 22:42

Mike (huttm@yahoo.co.uk) writes:
> 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).

That's spooky.

> 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...)

And there is space on the disk?

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

Since I don't have access to your system, it's difficult to try
things. So the easiest way out is probably to detach all user databases
if you have not done so already, and then reinstall. If you have lots
of logins or other server-level objects, that can be a bit painful.
The alternative would be to open a case with PSS.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]