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.
heard that it should be restored in a special way.
Thank you.
-
-
Re: temp db
Simply restart the service, the tempdb is created upon every SQL Server
Service start.
HTH, Jens Suessmeyer.
---
---
-
Re: temp db
What if I can't restart the server? What else can I do?
Comment
-
Re: temp db
tolcis (a.liberchuk@ve rizon.net) writes:[color=blue]
> What if I can't restart the server? What else can I do?[/color]
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@sommarsk og.se
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
Comment
Comment