temp db

Hi!  My tempdb crashed.  What is the correct way to restore it?  I
heard that it should be restored in a special way.
Thank you.

Simply restart the service, the tempdb is created upon every SQL Server
Service start.


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

What if I can't restart the server?  What else can I do?

tolcis (a.liberchuk@verizon.net)  writes:
> What if I can't restart the server?  What else can I do?

I don't know exactly what "crashed" means, but since tempdb is used for
both for temp tables and for worktables, I would expect an SQL Server
with a crashed tempdb, to be in bad shape, why a restart is about the
only way out.

Or does SQL Server appear to behave normally, save the crashed tempdb?

Note that you don't have to reboot the machine, just stop and start
SQL Server.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx