Can't open sql server - tempdb is marked as SUSPECT

[gillianm1]

Hi,
I'm trying to open SQL Server and can't because the tempdb has been marked as SUSPECT. Does anyone know how I can repair the tempdb?

Thanks in advance,
Gillian [sig][/sig]

 

[foxdev]

According to Microsoft:

To resolve a suspect database:
[tab]Check the SQL Server error log and resolve all problems.
[tab]Reset the suspect status by executing sp_resetstatus.

[sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[TomSark]

Make sure that you haven't run out of space as well. Rebooting the server should clear it out, but it may not be able to do so if it is already marked as suspect. Make sure autogrow is turned on, then do what Robert suggested.

Tom
[sig][/sig]