why you are restricting the tempdb size?

Hi;

Please any one help regarding this need.

Thanks for reply of member The_SQL_DBA

I'm realy sorry for that. Know I understand who can evaluate a DBA?

My answer is - only experienced DBA can.

I apologize for all...

May I know who is The_SQL_DBA?

Sorry! sir I apologize for that!:-)

I am Sorry for this complaint!

Gr8 sir:-D

That’s my question why the trying to confuse in interview? He told me that SQL server is not starting due to MSDB database corruption. And forcefully telling me that...

Sir Really I have lot of questions.

But a 11 years experienced DBA is hearts me!

Sorry! for incorrect spell

My concern is - Embarrassing - "Means to make some look bad"

Hi;

thanks to reply!

the concern is that If my Instance in not running and it is not able to start then how I will restore?

Thanks Lot! 🙂

This problem occurring due to default trace option enable

To avoid

EXEC master.dbo.sp_configure 'show advanced options', 1;

GO

EXEC master.dbo.sp_configure 'default trace enabled', 0;

GO

RECONFIGURE