Thursday, February 14, 2013 11:42 AM
Can anyone help me out please?
1) when u recycle ur sql services, what exactly it does inetrnally in the backend?
2) how the transactions are sent to secondary server, who sends them and how SQL server internally responds ?
3) when u stop your SQL server, what exactly SQL server does internally?
Monday, February 18, 2013 2:12 PM
Lots of stuff happens internally, bt what it sounds like you want to know is about transactions.
When a commit is issued, the TLOG is updated before the data is committed in memory (late to disk)
The recycle and restart makes sure the transactions that were committed get written to data file before database is brought bacck online.
The uncommitted transactions are rolled back to previous state.
replication and mirrors follow the same pratice.
TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA