Restart Instance

Question

Hi All,

If we restart SQL server instance what happens on the background and which phases are involving?

---

Raveendra

Answer 1

Hello Ravi,

Kindly have a look at below post for these details.

http://sqlconcept.com/2011/05/25/what-happens-when-a-sql-server-instance-is-restarted/

If you looks into error log, you can find some other information..

---

- Chintak (My Blog)

Answer 2

on the SQL Services are restared below actions are performed

tempdb is recreated as it is a globally shared database

sql server listening port is verified

database check db is done

to know more run xp_readerrorlog in you ssms  are read the errorlog

---

Ramesh Babu Vavilla MCTS,MSBI

A check db isn't run on SQL Server restart.  That message in the error log only tells you when it was last run.  Chintak's link seems pretty comprehensive to me

---

Thanks, Andrew

Answer 3

on the SQL Services are restared below actions are performed

tempdb is recreated as it is a globally shared database

sql server listening port is verified

database check db is done

to know more run xp_readerrorlog in you ssms  are read the errorlog

---

Ramesh Babu Vavilla MCTS,MSBI

A check db isn't run on SQL Server restart.  That message in the error log only tells you when it was last run.  Chintak's link seems pretty comprehensive to me

---

Thanks, Andrew

thanks Andrew verified and agreed with you deleted my asnwer too

---

Ramesh Babu Vavilla MCTS,MSBI