What are the steps involved during sql server service startup?

Question

What are the steps involved during sql server service startup?

Oracle_91

SSChampion

Points: 14548
More actions
May 21, 2014 at 5:46 am

#396790

Hi All,
What happens during SQL Server service startup ?
Basically, i am looking at step by step process of how sql server brings up the instance with all sp_configure settings,startup parameters etc..
Thanks in Advance.

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

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Check the SQL log for detail action.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Oracle_91 SSChampion Points: 14548 More actions · Answer 2

You mean, SQL Server Errorlog. Right ?

Thank you.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

That's not a quick explanation, that's a chapter. Specifically, it's a chapter in SQL Server 2005 Practical Troubleshooting (http://www.amazon.com/SQL-Server-2005-Practical-Troubleshooting/dp/0321447743/)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Oracle_91 SSChampion Points: 14548 More actions · Answer 4

Thanks Gail. I just came across your link.

http://www.sqlservercentral.com/Forums/Topic1208152-1550-1.aspx