|
Home > Archive > Microsoft SQL Server forum > April 2006 > temp db
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| tolcis 2006-04-06, 11:30 am |
| 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
---
| |
| tolcis 2006-04-06, 8:26 pm |
| What if I can't restart the server? What else can I do?
| |
| Erland Sommarskog 2006-04-06, 8:26 pm |
| 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
|
|
|
|
|