SQL Server Startup Activities

Question

Post reply

SQL Server Startup Activities

trivedi.nikesh

Right there with Babe

Points: 715
More actions
May 5, 2010 at 12:07 am

#221165

Hi All,
I am want to know that, what are the startup activities perform by SQL Server when it starts.
Please provide me the list of activities which are perform by SQL Server.
Thanks,
Nikesh

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

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

This should point you in the right direction...

http://msdn.microsoft.com/en-us/library/ms190737.aspx

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

trivedi.nikesh Right there with Babe Points: 715 More actions · Answer 2

Thanks for your response.

But I am looking for, list of those background activities, which are perform for SQL Server when is starts from scratch or restarts.

Like starting other dependent services, verification of system databases, user databases, consistency check ... etc .

Please put some light on this.

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

trivedi.nikesh (5/5/2010)
But I am looking for, list of those background activities, which are perform for SQL Server when is starts from scratch or restarts.

:blink: This is the "Working with Oracle" section of the forum - unusual place to post this question.

Do you have access to BOL?

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.