April 29, 2008 at 12:26 pm
Very Very Urgent....Tempdb Full...Not able to open server from Enterprize Manager or Management Studio..Any ideas what to do:hehe:
April 30, 2008 at 1:28 pm
stop your sqlserver
delete the tempdb.mdf under your program files\Microsoft SQL Server\MSSQL.x\MSSQL\data folder
restart your sqlserver
this will recreate the tempdb back to the initial size by default (8MB) if you didn't change the default size.
May 9, 2008 at 7:13 am
hey before you delete tempdb, take a backup of it, and then delete.
Thanks!
Pramod.
May 9, 2008 at 7:50 am
jpchiu (4/30/2008)
stop your sqlserverdelete the tempdb.mdf under your program files\Microsoft SQL Server\MSSQL.x\MSSQL\data folder
restart your sqlserver
this will recreate the tempdb back to the initial size by default (8MB) if you didn't change the default size.
There's no reason to delete anything. Restarting the service will resize tempdb to whatever the starting size is set to. You start out with a "clean" tempDB every time....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
May 9, 2008 at 9:17 am
Follow Matt's advice. Dont' delete anything.
Can you connect with iqsl and do a dbcc opentran in tempdb?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply