History TEMP DB

Hello ,

Could you please help me with this problem ?

Somebody change the Temp DB size and I want to know if is any method to find  that person .(sql log not help )

Thank you !

C.
Catalin DobritoiuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Nope, without any profiler traces or extended events enabled to capture the file growth or file size modification, you can't identify who changed it in SQL Server without any third party tools in place.
FYI, please check whether your SQL Server services got restarted or not as it will make your tempdb size to its initial size configured.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Why do you think it was a person that made the change and not the SQL Server engine itself?
tempdb is allowed to autogrow by default so it's mostly sure that was the engine that performed a change in the file size to be able to perform an operation.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Catalin, a feedback will be appreciated.
Cheers
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Initiating Auto close as we haven't heard back from Author and valuable solutions provided..
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.