What is the trace no. for tempdb

Question

Post reply

What is the trace no. for tempdb

forsqlserver

SSCoach

Points: 18902
More actions
August 26, 2011 at 2:04 am

#242940

What is the trace no. on using which the tempdb database doesn't create in startup of sql server service?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

NJ-DBA SSChampion Points: 13834 More actions · Answer 1

Can you please rephrase your question? This doesnt really make sense. What are you trying to determine?

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 2

What you are asking for is a traceflag.

http://sugeshkr.blogspot.com/2009/01/introduction-to-sql-server-trace-flags_14.html

3609 - Skips the creation of the tempdb database at startup. Use this trace flag if the device or devices on which tempdb resides are problematic or problems exist in the model database.

forsqlserver SSCoach Points: 18902 More actions · Answer 3

forsqlserver

SSCoach

Points: 18902

August 26, 2011 at 6:33 am

#1373714

Hi,

Thanks,

Thanks