Avatar of sadiya yousaf
sadiya yousaf
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Tempdb drive is full

Hi Everyone

Need help again.

I know nothing about SQL server and had email from the company who maintain our servers that some drives on sql server are full.
One of the drive has tempdb.ldf and tempdb.mdf files. Google guru tells me to restart SQL server service , tempdb will reset itself and create free space. It would not affect the Sql database functionality as tempdb hold information on temporary basis. Please confirm / advise

I am assuming I will have to restart the SQL server services from services and it will do the job.

Thanks in advance
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
sadiya yousaf

8/22/2022 - Mon