Posted by Erland Sommarskog on 10/02/17 11:44

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: rights issues with linked server
• Prev in forum: Re: Row Numbers for a View
• Thread view: Re: temp db

[Reply to this message]